I am a firm believer that boiling down a problem into its simplest form is the fastest way to solving it. I also think one of the fundamentals of programming is breaking a problem into a bunch of smaller problems. If you combine these together, you get test cases out...
While it is great that Qlik offers a free desktop, I usually suggest trying to set up a server environment for local development. I personally run a Windows Server virtual machine (VM) with QSE installed, which I can access with my browser. I do it this way for three...
Description This covers how to use Qlik to insert data from a Qlik table into a SQL database using script generation. This is done for all tables within a Qlik model where the Qlik and Database table and field names are the same. *There is no data type...
In other words, user defined functions. With utilizing variable parameters, you can create your own functions touse later. For example, a function to calculate the number of weeks between two date fields: SET fWeekDiff = '(((Year($2)*52)+Week($2))) -...
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...
