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...
74 – SubField

74 – SubField

If you are like me, you probably use SubField a lot. I had used it for years before I stumbled across one of its most powerful features in someone else’s code. If you do not provide the position parameter, it will expand a record for each delimited value. I’ve worked...
75 – Arrays

75 – Arrays

Arrays and/or Lists are very common in programming languages. In Qlik scripting there are two ways to go about creating an array of sorts. The first way is storing a list in a variable: The second way is by using a field: Source Result: The main use of these will be...