71 – Copy Paste

71 – Copy Paste

There’s nothing worse than waiting for a long reload to find out you made a typo. One thing I have made a habit of is copy and pasting script items: table names, field names, variables, etc… This is definitely a simple item, but it can save you a ton of time down the...
72 – Dual Set Analysis

72 – Dual Set Analysis

By default you need to reference the display (read: string) value of a dual field in set analysis versus the numerical value. I personally think this is a weird behavior of Qlik, however it is what it is. The downside to this is that string operations are much slower...
73 – Wildcard Load

73 – Wildcard Load

One good thing to know is that you can use an asterisk * within a file name. Qlik will load all the files that fit the criteria. Say you have a directory named QVD, which has all of your QVDs prepped and ready for your data model. You can simply do the following to...