topic Re: Syntax issue in QlikView

Syntax issue

bharatkishore — Mon, 28 May 2018 13:16:43 GMT

Hi All,

i have the below sql code :

where (IB <>0 and IB is not NULL)
or (Consumption<> 0 and consumption is not NULL);

and when i write in qlikview i am getting 0 records.. Qlikview code is below on:

where (IsNull(IB) and IB<>'0') or (IsNull(Consumption) and Consumption<>'0')

Can you please tell me where i am doing wrong.

Thanks,

Bharat

sunny_talwar — Mon, 28 May 2018 13:22:01 GMT

I think the SQL query is saying is not null, but you are doing IsNull in QlikView?

May be you want this

Where (NOT IsNull(IB) and IB <> '0') or (NOT IsNull(Consumption) and Consumption<>'0')

bharatkishore — Mon, 28 May 2018 13:24:04 GMT

Thank you sunny bhai.. just saw that and replaced My bad..

sunny_talwar — Mon, 28 May 2018 13:28:55 GMT

No problem