topic Help pls on Single qutoue in QlikView

Help pls on Single qutoue

Fri, 18 Nov 2011 06:21:11 GMT

I am having problem with using of Single quote. Actually i am loading incremental data based on max date. In my script I am using date_field > '20-Jun-2011'

To get this I declared a variable for single quote and using for maxdatevariable.

find the attached screenshot

Help pls on Single qutoue

Fri, 18 Nov 2011 06:31:35 GMT

hi, use chr(39) function, which returns sigle code...

Help pls on Single qutoue

SunilChauhan — Fri, 18 Nov 2011 07:10:08 GMT

in ur code as shown i png

use this

let vchkdt='10/28/2011' ; in place of let vchkdt='10/28/2011'';