topic Re: Nesting variables in script for set analysis in QlikView

Nesting variables in script for set analysis

h_demarco — Mon, 25 Jul 2016 21:47:26 GMT

Folks,

I have a variable in my script that is

Set var_IAP= =Sum({<Tipo_ap={Produção}, ETAPA-={50,21,100}>} QUANTIDADE)

'Etapa' exclusion is very common and I need to change it frequently (include another number like 200), so I created a new variable:

Set var_etapa_excluir= , ETAPA-={50,21,100};

And now I am trying to nest both using:

=Sum({<Tipo_ap={Produção} var_etapa_excluir >} QUANTIDADE)

Note that in many cases I need to exclude 'Etapa', but not in all cases. So my concern is to use as a variable, to avoid editing all the script that has more than 20 other variables.

In chart I just use var_IAP.

What is the correct way to nest variables in script? What am I doing wrong?

Thanks and best regards.

Re: Nesting variables in script for set analysis

sunny_talwar — Mon, 25 Jul 2016 22:08:50 GMT

You might have to play around with this to get this to work:

Re: Expression as a variable with $-sign expansion

Stop Dollar Sign Expansion in the script (Escape Character ??? )

Re: Nesting variables in script for set analysis

qliksus — Tue, 26 Jul 2016 03:53:45 GMT

Not sure if I have understood you correctly ? If you say you have to exclude ETAPA for some cases so why cant you put that case outside the SET like

If case1 , sum({<ETAPA-={0,1,200}> } amount) else sum(amount) and do you really need to create 2 variables as you can edit the filters in the ETAPA even if you use 1 variable

Re: Nesting variables in script for set analysis

jonathandienst — Tue, 26 Jul 2016 05:13:59 GMT

This should work:

Set var_etapa_excluir= , ETAPA-={50,21,100};

Set var_IAP = =Sum({<Tipo_ap={Produção} #(var_etapa_excluir) >} QUANTIDADE);

Let var_IAP = Replace(var_IAP, '#', '$');

The reason for two steps for var_IAP is to defer the $ expansion of var_etapa_excluir until the expression is evaluated in the front end. "Set" will expand the variable so it will no longer be dynamic.

We substitute # for $ to prevent the expansion and put it back with the replace step. The replace does not trigger the expansion.

You may get syntax warnings because the syntax check does not know what you intend to do with the variables.

Re: Nesting variables in script for set analysis

h_demarco — Wed, 27 Jul 2016 19:57:45 GMT

I think my explanion was not clear, but below explanation may help:

I have 100 variables and 80 of them contain <ETAPA-={0,1,200}>. If I want to include one ETAPA number into array like <ETAPA-={0,1,200,205}>, will I need to change 80 lines of code?

Re: Nesting variables in script for set analysis

h_demarco — Wed, 27 Jul 2016 20:01:33 GMT

Yeahh... it worked!

Thank you so much.