Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
MVP
MVP

Re: Ch(39) produces double quotes instead of one

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.

Highlighted
Creator
Creator

Re: Ch(39) produces double quotes instead of one

Hi there,

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

kindly below:

Highlighted
Creator
Creator

Re: Ch(39) produces double quotes instead of one

Hi there,

how do i get rid of one,

i only need to have one single quote.

Highlighted
MVP
MVP

Re: Ch(39) produces double quotes instead of one

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

Highlighted
Creator
Creator

Re: Ch(39) produces double quotes instead of one

Attached  is the sample app called QVD.

Highlighted
MVP
MVP

Re: Ch(39) produces double quotes instead of one

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.

Highlighted
Creator
Creator

Re: Ch(39) produces double quotes instead of one

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

Highlighted
Creator
Creator

Re: Ch(39) produces double quotes instead of one

Below is the picture of the script.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Ch(39) produces double quotes instead of one

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