Using Spaces in Set Analysis Values

[ltc]

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?

[agigliotti]

try using single quote as below:
[Program Type] = {'A 1', 'I 2'}

[sunny_talwar]

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"}>}

[jonathandienst · Accepted solution]

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"

[ltc]

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.

[ltc]

Yes, single quotes would have worked, but I specifically wanted double quotes to account for lower-case spelling variations.