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

How to hide my table row with zero value ?

paulyeo11 — Wed, 26 Oct 2016 10:09:56 GMT

Hi All,

I have a table , i am unable to remove those row with zero value. Hope some one can help me.

Diamension :-

COMPANY_PAY

=If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2),

If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4),

If(aging_ar >= 121 and aging_ar <= 150, Dual('121-150', 5),

If(aging_ar >= 151 and aging_ar <= 180, Dual('151-180', 6),

If(aging_ar >= 181 and aging_ar <= 210, Dual('181-210', 7),

If(aging_ar >= 211 and aging_ar <= 240, Dual('211-240', 8),

If(aging_ar >= 241 and aging_ar <= 270, Dual('241-270', 9),

If(aging_ar >= 271 and aging_ar <= 300, Dual('271-300', 10),

If(aging_ar >= 301 and aging_ar <= 330, Dual('301-330', 11),

If(aging_ar >= 331 and aging_ar <= 360, Dual('331-360', 12),

If(aging_ar >= 361 and aging_ar <= 390, Dual('41-270', 13), Dual('>12 Mth', 14))))))))))))))

Expression :-

Sum(total_ar)

Paul.

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

paulyeo11 — Wed, 26 Oct 2016 10:10:44 GMT

my QVW

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

gajapathy74 — Wed, 26 Oct 2016 19:48:39 GMT

hmmm

you have another post How to hide my pivot table whole row with zero value? and hope the solution is helpful.

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

paulyeo11 — Wed, 26 Oct 2016 19:57:06 GMT

This is because , after I submit my first post 6 hr , I go and check and found out that it is not appear at forum , so I thou it never send thou , so I resend . Sorry

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

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

gajapathy74 — Wed, 26 Oct 2016 19:59:21 GMT

Okay

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

Frank_Hartmann — Wed, 26 Oct 2016 20:15:48 GMT

see attached qvw

hope this helps