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...
Like most other programming languages, it is important to decide and follow some programming standards, evem with naming conventions. One key standard is how to name things. Now I’m not here to say that you should name things the way I do, that isn’t the point. What...
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...
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...
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...
