Skip to main content

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 ...

Return to blogging

· One min read

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.