topic Re: Where Clause text literal issue in QlikView

Where Clause text literal issue

Mon, 07 Apr 2014 05:22:52 GMT

Dear,

kindly guide me how to ignore ' in text literal when using in conditon for example,

load *

where rate_desc='N'cash'; its show me error. Condition value is N'cash

tresB — Mon, 07 Apr 2014 05:27:03 GMT

Try like:

where rate_desc='N'&chr(39)&'cash' ;

amit_saini — Mon, 07 Apr 2014 05:39:44 GMT

Hi Zainulabedeen,

If you want to ignore N'cash , Try this:

where rate_desc <>' N'cash' ;

or try this:

where rate_desc <>'N'&chr(39)&'cash' ;

Thanks,
AS

Mon, 07 Apr 2014 06:01:57 GMT

Thanks dear, i have done with your help.

Regards,

Zain.

Mon, 07 Apr 2014 06:02:47 GMT

Thanks for your reply.

Regards,

Zain.