★【World Of Moshow 郑锴】★

Backgroundqlik sense doesn’t provide a function to quickly extract the value from the json ,so we have to use many origin functions to get value from the json.QLIK SENSE本身并没有提供一个JSON解析方法可以直接从JSON中提取值,所以必须用原生方法进行拼凑来提取值.RequirementGiven that we connect t

前言:Qlik sense的script log是非常多的,需要定期清理,所以本程序用的是powershell进行编写,功能如下:- 复制半年前的日志(.AddDays(-180)可以修改具体的时间)到Temp文件夹- 用7Zip压缩日志文件夹并保存为.zip- 删除已经备份好的半年前日志文件

Background有时候我们需要用qlik对数据进行分组范围匹配,例如匹配60分到80分为good,80分到100分为excellentSometimes we need to use qlik to group the data in range, for example, matching 60 points to 80 points as good, 80 points to 100 points as excellentSulutionScore:LOAD * Inline [Sc

BackgroundIn Qlik Sense, all communication between services and the Qlik Sense web clients is based on web protocols. The web protocols use Secure Sockets Layer (SSL) for the following:Encryption and exchange of information and keysCertificates for auth

BacckgroudHow can we do if we forgot the qlik pgsql password.Reset the forgotten passwordAdd a new superuserConnection information for reference:PropertyValueConnection NamePostgreSQL_localhostHost NamelocalhostPort4432Database

Backgroudwe got the issue on FirstSortedValue , FirstSortedValue(Onborded_Date, Onborded_Date) AS Customer_First_Onborded_Date , it will display -(null) if met duplicate records. eg some records are have the same Onborded_Date.about how to use the FirstS

前段时间得到一个任务，做个增量备份批处理脚本。语言PowerShell，压缩软件7z，所以就有了这个`incremental backup script | 增量备份`的solution。1. 从`lastBackup.txt`文件中获取`最后一次保存时间` 。2. 通过增量复制（判断LastWriteTime>上次修改时间）源文件夹 。sourcePath中需要备份的文件到temp临时目录 。3. 7z压缩temp目录到目标文件夹destinationPath 。4. 回写最新备份时间。

BackgroundIts complex and repeatable to stop and start qlik services when in maintain.So we can write down a powershell script to auto restart the qlik services.每次qlik服務器有問題的時候,都需要停止和重啓服務,這個時候如果用po...

BackgroundFolder %AppData%\Roaming\Microsoft\Crypto\RSA filled up with hundreds of small filesknowledge from https://support.qlik.com/articles/000070548Folder %AppData%\Roaming\Microsoft\Crypto\RSA...

前言现在经常要和Qlik Sense打交道，通常企业用的比较多的是Hub版，但是对于个人而言，Desktop是免费且不错的。什么是Qlik Sense Desktop？Qlik Sense Desktop 是一个 Windows 应用程序，让个人用户有机会使用 Qlik Sense 并通过多个数据源以简便的拖放操作创建个性化、交互式数据可视化、报告和仪表板。个人和内部业务使用时免费。您可以...