topic Re: Where condition in QlikView

Where condition

varunreddy — Fri, 05 Aug 2016 16:15:40 GMT

Hi Guys,

I am trying to obtain the results only when a <> 0 and b<>0.

I am trying this:

select * from table where a<> 0 and b<>0.

This is also eliminating the values where a=0 and b has value and when a has value and b is 0.

Scenario:

a=0 and b=0 -- Should not be displayed

a=0 and b=19 -- should display

a=21 and b=0 -- should dispplay

Thanks in advance.

Cheers,

Varun Reddy

antoniotiman — Fri, 05 Aug 2016 16:27:35 GMT

Hi,

try

Where NOT (a=0 and b=0)

Regards,

Antonio

vinieme12 — Fri, 05 Aug 2016 16:27:55 GMT

You need OR operand

select * from table where a > 0 OR b > 0.

vishsaggi — Fri, 05 Aug 2016 16:28:10 GMT

My be try this

Where (A > 0 OR B > 0)

varunreddy — Fri, 05 Aug 2016 16:39:35 GMT

Hi All,

Thank you for the quick response.

Cheers,

Varun Reddy