Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a text variable containing (')

I Need to create a string variable that includes the character ', for example:

Let vCSAC='{$<Dept={'A','B','C'}>}';

can anyone assist

Labels (1)
1 Solution

Accepted Solutions
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Try this

LET vCSAC = '{$Dept={' & chr(39) & 'A' & chr(39) & ',' & chr(39) & 'B' & chr(39) & ',' & chr(39) & 'C' & chr(39) & '}>}';

View solution in original post

2 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Try this

LET vCSAC = '{$Dept={' & chr(39) & 'A' & chr(39) & ',' & chr(39) & 'B' & chr(39) & ',' & chr(39) & 'C' & chr(39) & '}>}';

isorinrusu
Partner - Creator III
Partner - Creator III

Use Set instead of Let:

Set vCSAC1= {$<Dept={'A','B','C'}>};