973-584-9100 contactus@bardess.com
70 – Pick Match

70 – Pick Match

One of the most resource intensive functions in a chart is the If statement. In a lot of scenarios, what you can do is leverage the combination of Pick and Match to replicate the functionality while increasing performance. Example If you need an Else condition, there...
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...