Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ch(39) produces double quotes instead of one

Hi

I have an issue where iI'm using Chr(39) , however the result produces a double quote.  I have 2 variables.

let vQvd = 'QVD' & chr(39) & 's';

and

let vQvdlocation ='\\Intranet.barcapint.com\dfs-emea\GROUP\Jhb\TAT - Production\$(vQvd)\GLRS';

However the solution in the front end in a text box displays as follows:

Capture.JPG

Please can you help.  Thanking you in advance.

Kind regards

Nayan

9 Replies
tresesco
MVP
MVP

I guess it's not a double quote but two single quotes. Not only that, I guess vQvd=QVD's , but I don't see the 's in your screenshot.

Anonymous
Not applicable
Author

Hi there,

i had commented it out at that momentCapture.JPG sorry,

kindly below:

Anonymous
Not applicable
Author

Hi there,

how do i get rid of one,

i only need to have one single quote.

tresesco
MVP
MVP

I could not reproduce the issue. Could you share your sample app?

Anonymous
Not applicable
Author

Attached  is the sample app called QVD.

tresesco
MVP
MVP

Access denied. Also it's a big file. To check the variables, no data would be required; you could reduce and share a smaller app.

Anonymous
Not applicable
Author

Hi there,

im not sure why you denied access,

kindly see below script of whats in the model, thats all there is in there.

script.JPG

Anonymous
Not applicable
Author

Below is the picture of the script.

marcus_sommer

For me it worked. But I see that you used two different variables: vQvdlocation and vQvdLocation between your origin question and the later screenshot. Therefore check if you really look on the right variable.

- Marcus