topic Re: chr(39) is producing double quotes in QlikView

chr(39) is producing double quotes

Mon, 30 Sep 2013 14:16:35 GMT

Hi Guys,

I am using the following statement

set cDate = '2013-09-24 18:32:59'

let ndate = 'Time <=' & chr(34) & '$(cdate)' & chr(34);

and expecting

ndate to be Time <= '2013-09-24 18:32:59'

but it is producing a string like this

"Time <="2013-09-24 18:32:59""

Any Solutions?

Chr(39) is producing double quotes instead of single qoute.

Saurabh

Re: chr(39) is producing double quotes

mvanlutterveld — Mon, 30 Sep 2013 14:35:32 GMT

Hi Ramya,

Try this:

set cDate = '2013-09-24 18:32:59';

let ndate = 'Time <=' & chr(39) & '$(cDate)' & chr(39);

Michiel

Re: chr(39) is producing double quotes

Mon, 30 Sep 2013 15:12:16 GMT

It is little bit strange.

If you see my subject of this post, it talks about chr(39) giving double quotes which was actually happening.

So i was just testing chr(34) to see if that produces single quote which it did not do and i posted a wrong question but when i thought to try the chr(39) again after looking at your post then it is working.

I have no idea.

Is there any external factor that determines the behavior of chr(39)?