973-584-9100 contactus@bardess.com
96 – Clear Your Variables

96 – Clear Your Variables

This is a very short and sweet one. Clear your variables. Trust me, it is worth it. It’s easy and will save you time debugging. To clear a variable just do: vVariable=; Also if you tend to copy apps as starting points, don’t forget to delete old variables. The...
98 – Change Log

98 – Change Log

This one is more of a process I wish I had started doing sooner. Nowadays in every app I build, I create a script section named ‘Change Log.’ This little piece of documentation gives a bit of background on the app, and then a list of changes over time with tags to be...
99 – Inline Load Delimiter

99 – Inline Load Delimiter

One thing which would have been useful years ago was knowing I could copy data directly from Excel into the load script for an Inline Load if I changed the delimiter setting in the load script. So what this means is you can copy a data set from Excel: Paste into Qlik...
100 – AutoGenerate

100 – AutoGenerate

You might have noticed I used this in the last example. AutoGenerate is so useful and has so many use cases. I probably use this in every app I create: from empty stub tables, generating a new field using another’s unique values, or as a way to log different steps...
}