topic Set Analysis with Apostrophe in QlikView

Set Analysis with Apostrophe

Wed, 18 Feb 2015 09:50:17 GMT

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 — Wed, 18 Feb 2015 09:52:04 GMT

maybe

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

PrashantSangle — Wed, 18 Feb 2015 10:12:44 GMT

Hi,

It work inside ""

Try like

"SR's Open"

Regards

Wed, 18 Feb 2015 10:13:23 GMT

Please try like this,

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

Regards,

Faisal