Here is to the start of a new blog series I am doing called ‘101 Things I Wish I Had Known Sooner’. Each post will contain a straight and to the point thing that I, well… wish I had known sooner. To start it off I am going to talk about Qlik Subroutines.
A subroutine is a user defined program within your script that you can call at a later time.
Let RC.Rows = Num(NoOfRows('$(pRowTable)'),'#,##0');
Trace ---------------- $(pRowTable): $(RC.Rows) rows;
Rand() as Random
Chr(IterNo()) as Char
IterNo() <= 2;
Drop Table Temp;
This is a very simple example, but you can start to see the possibilities.