Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnacbe
Partner - Specialist III
Partner - Specialist III

Alternate State in Variables

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.

1 Solution

Accepted Solutions
2 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant
sunny_talwar

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 ??? )