topic Re: Using Spaces in Set Analysis Values in App Development

Using Spaces in Set Analysis Values

ltc — Fri, 02 Apr 2021 07:45:48 GMT

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?

Re: Using Spaces in Set Analysis Values

agigliotti — Wed, 23 Jan 2019 16:06:10 GMT

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

Re: Using Spaces in Set Analysis Values

sunny_talwar — Wed, 23 Jan 2019 16:06:59 GMT

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

Re: Using Spaces in Set Analysis Values

jonathandienst — Thu, 24 Jan 2019 05:35:18 GMT

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"

Re: Using Spaces in Set Analysis Values

ltc — Thu, 24 Jan 2019 17:25:25 GMT

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.

Re: Using Spaces in Set Analysis Values

ltc — Thu, 24 Jan 2019 17:26:28 GMT

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