Syntax issue

[bharatkishore]

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 · Accepted solution]

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]

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

[sunny_talwar]

No problem