topic Re: Single Quotes in Set Analysis in QlikView

Single Quotes in Set Analysis

Wed, 01 Oct 2014 18:29:27 GMT

I'm doing a SET at scale analysis of a table:

= NameField = 'Example's'

How do I igonrar the single quotes between the E and S?

Thank's.

JonnyPoole — Wed, 01 Oct 2014 18:44:36 GMT

try using chr(39) as follows:

sum( {$<NameField={$(='Example' &chr(39)&'s')}>} Sales)

maxgro — Wed, 01 Oct 2014 18:49:06 GMT

using double quotes

sum({$ <NameField={"Example's"}>} Sales)

Wed, 01 Oct 2014 19:24:20 GMT

But I wanted to throw this example a calculated dimension.

JonnyPoole — Wed, 01 Oct 2014 19:51:30 GMT

Can you post the Calculated Dimension formula you are working on ?

replace() and purgechar() are also helpful functions here, but specifics are important.