topic Re: How to hide my table row with zero value ? in QlikView

How to hide my table row with zero value ?

paulyeo11 — Tue, 13 Sep 2016 22:41:03 GMT

Hi All

My Table 2 column 1 & 2 display correct value , but there are many null value , may i know how to remove those null value row.

So that i can compute sum for column base on column 1 and 2 .

My dimension my field is company_ar , I have try surpress when value is null

Paul.

paulyeo11 — Tue, 13 Sep 2016 22:41:40 GMT

my qvw

sunny_talwar — Tue, 13 Sep 2016 23:57:36 GMT

Are you looking to see only those rows where both expressions are not equal to 0?

sunny_talwar — Tue, 13 Sep 2016 23:59:14 GMT

Like the attached?

paulyeo11 — Wed, 14 Sep 2016 00:02:25 GMT

WOW ! you are good. the expression is so complicated. Thank you sunny.

sunny_talwar — Wed, 14 Sep 2016 00:03:55 GMT

I didn't do much paul. Just used both your expressions to check if both of them are greater than 0 or not

If(Exp1 > 0 and Exp2 > 0, Exp1) -> 1st Expression

If(Exp1 > 0 and Exp2 > 0, Exp2) -> 2nd Expression

paulyeo11 — Wed, 14 Sep 2016 00:08:33 GMT

Hi sunny

I just notice that what i look for is those column for >180 Days row which is zero to be remove.

( Ad those customer debt more then 120 days and Yet Last 5 Month sales zero , are consider very risky customer )

Hope you can help me.

Paul

sunny_talwar — Wed, 14 Sep 2016 00:10:53 GMT

Check if this works then

paulyeo11 — Wed, 14 Sep 2016 00:28:41 GMT

Yes , it work fine. Thank you for your help.