Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Single Quotes in Set Analysis

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.

4 Replies
JonnyPoole
Employee
Employee

try using chr(39) as follows:

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

maxgro
MVP
MVP

using double quotes

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

Not applicable
Author

But I wanted to throw this example a calculated dimension.

JonnyPoole
Employee
Employee

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

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