We all know that there are functions in Qlik, but we know little about macro functions. What is it?

It's the functions which simplify the development!

For example, I want to output to the script execution console the number of rows of the table just loaded, as I did before?

LET myVar = NOOFROWS('myTable');
TRACE 'myTable has $(myVar) rows';
SET myVar;

And now?

$(eRows('myTable'));

What's Easier for You?

Macro functions examples:

• To find the minimum value in a field and store it in a variable with a single line of script?
• To delete a table if it exists with a simple command?
• To perform Concatenate/NoConcatenate without having to think about exist table or not? and other ...

How?

Where can I find downloads for Qlik products and obtain a trial license for Qlik Sense Desktop?

Let's say you need to extract only unique values from a variable that can be input by the user in a visual part.

It has been several years since I initially began writing informative posts about Qlik on my blog. Now is the time to revisit and continue this effort.