Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
Let myVar = 'pick($' & '(YTDToggle),''something'',''something else'')';
Note the two single quotes for esacping the single quotes around your literal strings.