Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using the attached set analysis expression and it is giving me an Error.
I noticed that when I remove the space between "A 1" and "I 2" that the expression is then OK.
Why wouldn't I be able to use a space if that is what my values are?
How do I fix this?
It looks like you built the expression in Excel (or some other auto-correcting editor) -- the quotes are not the correct characters. Replace them with normal quote characters in the Qlik script editor.
“One, Two” should be "One, Two"
Did you try to press okay and see if the expression worked or not? Also, can you try this
{<[Program Type] = {"A?1", "I?2"}>} or {<[Program Type] = {"A*1", "I*2"}>}
It looks like you built the expression in Excel (or some other auto-correcting editor) -- the quotes are not the correct characters. Replace them with normal quote characters in the Qlik script editor.
“One, Two” should be "One, Two"
You're right! I was copying & pasting the expression from Word. Word was using "Smart Quotes" which I had to disable. Qlik doesn't recognize these Smart Quotes.
Yes, single quotes would have worked, but I specifically wanted double quotes to account for lower-case spelling variations.