Questions on Parameterized variables in Qlik

vish123 — Thu, 27 Mar 2025 19:55:44 GMT

Hi Team,

I am facing a challenge that i am unable to pass string value using $1 variable to another variable.

=$(vVariable1($(vVariable2)))

vVariable1 = Fractile($1 Aggr(Median($1 Metric),VIN),0.1)

vVariable2= {1<Set={4}, Dim2=P( ID), Dim1={1}, $3, $4>}

Here i wanted to pass entire vVariable2 to vVariable1 inplace of $1 , My expressions working fine if i put this set analysis value to the above function but when i am trying to pass this value via parameter . its not getting passed. Please suggest.

Thanks

Vish

Re: Questions on Parameterized variables in Qlik

Lech_Miszkiewicz — Fri, 28 Mar 2025 01:42:46 GMT

Hi @vish123

This is because variable parameters are inserted into your vVariable1 as comma separated value parameters.

When you look at your vVariable2 variable it is a list of comma separated values being

{1<Set={4},
Dim2=P( ID),
Dim1={1},
$3,
$4>}

When your expression gets parsed in vVariable1 it will be parsed as:

Fractile({1<Set={4} Aggr(Median({1<Set={4} Metric),VIN),0.1)

It is very well known scenario and there are other topics describing it already on community.

On top of that there is another issue when you have more than 9 parameters as 10th parameter if not declared can be also causing issues. More on those below:

cheers

topic Re: Questions on Parameterized variables in Qlik in App Development

Questions on Parameterized variables in Qlik

Re: Questions on Parameterized variables in Qlik