What are Macro-functions in Qlik?
· 2 min read
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 ...