Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET evaluation

Hi

I have a variable (called YTDToggle) which contains either a 1 or a 0 and is used to toggle/keep track of something in the front end.  In the load script it gets assigned a default value of 1.

I am trying to create another variable using the SET statement which looks something similar to this:

SET myVar = 'pick($(YTDToggle),'something','something else');

Regardless of what syntax I choose the result end up like this:

myVar = 'pick(1,'something','something else');

How can I prevent the $(YTDToggle) evaluting to it's result, in this case 1?

Thanks

Oli

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

Try

Let myVar = 'pick($' & '(YTDToggle),''something'',''something else'')';


Note the two single quotes for esacping the single quotes around your literal strings.

View solution in original post

1 Reply
swuehl
Champion III
Champion III

Try

Let myVar = 'pick($' & '(YTDToggle),''something'',''something else'')';


Note the two single quotes for esacping the single quotes around your literal strings.