topic Alternate State in Variables in QlikView

Alternate State in Variables

krishnacbe — Tue, 05 Jun 2018 15:49:40 GMT

Hi All,

I got some issues in using Alternate state in variable assignment in Script.

Var1 = Maxstring({State1}Dimenstion1)

Var2 = Sum({Dimension1={$(=$(Var1))}Sales)

If I use Var2 definition is used directly in Chart expression, it works. But if I move that to Script I am not getting right answer. Can anyone help me to fix this.

Thanks in advance.

Re: Alternate State in Variables

kfoudhaily — Tue, 05 Jun 2018 16:03:02 GMT

hello,

you cannot use set analysis in script.

your expression should be declared in variables editor directly.

to be able to reproduce set analysis in scipt you should use the option "grouped by"

regards,

Re: Alternate State in Variables

sunny_talwar — Tue, 05 Jun 2018 16:06:05 GMT

Look here for the problems related to $() in the script and there solutions

Expression as a variable with $-sign expansion

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