Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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

1 Reply
Not applicable
Author

bump