Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I wanted to use a variable with parameter and use 'total' as parameter. Like this expression
$(eCountDistinct( total ))
So far so good.
When I want to expand the total with 2 parameter like 'total <product_level1, product_level2>' the comma is interpreted as the end of the variable parameter.
The following examples don't work:
How can I solve this?
Digvijay -
Would you be able to elaborate on the usage of $0? I have never used that before and would love to learn about it. Would you be able to share a sample or a link where I can read about it?
Thanks,
Sunny
Hi,
Here is the detail -
The parameter $0 returns the number of parameters actually passed by a call.
set MUL='$1*$2 $0 par';
set X=$(MUL(3,7)); // returns '3*7 2 par' in X
Link from help -
Dollar-sign expansion using parameters ‒ Qlik Sense
Thanks,
Make sense. Thanks for sharing that