topic IF Statement in QlikView

IF Statement

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would appreciate some help with a simple question, that I am struggling to fix.

I have a straight table with two calculations in column(1) and column(2). I would like to only show records where column(1)-column(2)=0

Regards,

Daniel

tresB — Mon, 16 Dec 2019 09:56:09 GMT

Modify your col1 and col2 expression to something like:

Col1 Exp:

If(column(1)-column(2)=0, <Existing Expression1> , 0)

Col2 Exp:

If(column(1)-column(2)=0, <Existing Expression2> , 0)

Then with default zero value suppression setting, you should get what you want

danielnevitt — Mon, 16 Dec 2019 10:52:30 GMT

Thank you for your quick response.

I have included existing expression 1 (below), however I get an error. Do you know what the issue might be?

If(column(1)-column(2)=0, Count({<Side={'Buy'}>}Symbol , 0)

Regards,

Daniel

tresB — Mon, 16 Dec 2019 10:54:46 GMT

Missing a brace :

If(column(1)-column(2)=0, Count({<Side={'Buy'}>}Symbol) , 0)