Solved: Set Analysis with Apostrophe - Qlik Community

Report Inappropriate Content · ‎2015-02-18

Hi Guys

I have a field called 'Category':

In this field i have text called: SR'S OPEN.

Im trying to perform a set analysis:

=Sum({$<[Category]={'SR' & chr(39) & 'S OPEN'}>} Data)

but this does not work. I think its the apostrophe that erroring.

Any suggestions?

Regards,

Magen

maxgro · ‎2015-02-18

maybe

=Sum({$<[Category]={"SR'S OPEN"}>} Data)

View solution in original post

maxgro · ‎2015-02-18

maybe

=Sum({$<[Category]={"SR'S OPEN"}>} Data)

PrashantSangle · ‎2015-02-18

Hi,

It work inside ""

Try like

"SR's Open"

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-02-18

Please try like this,

=Sum({$<[Category]={'SR''S OPEN'}>} Data)

Regards,

Faisal