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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using single quotes around a $-expansion containing chr(39)

Hi

I've picked up this problem moving from QV9 to QV10. The handling of single quotes seems to be borken? I hope I can make this clear....

Given the following variables:

     SET vVAL1 = Bob;

     LET vPARM1 = 'PARM1 = ' & chr(39) & vVAL1 & chr(39);

Why does TRACE $(vPARM1); produce this output: PARM1 = 'Bob' (as one would expect)

while        TRACE '$(vPARM1)'; produces               'PARM1 = ''Bob''' (notice the doubling of the single-quotes around Bob)

Thanks,

Brian

Labels (1)
1 Reply
Not applicable
Author

bump