How to hide my pivot table whole row with zero value?

paulyeo11 — Wed, 26 Oct 2016 08:09:39 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 pivot table whole row with zero value?

paulyeo11 — Wed, 26 Oct 2016 08:10:52 GMT

my QVW

sunny_talwar — Wed, 26 Oct 2016 16:06:29 GMT

Like this? Check 'Suppress Zero-Values on the Presentation tab?

paulyeo11 — Wed, 26 Oct 2016 23:19:58 GMT

Hi Sunny

Thank you very much . i notice that Qlik View have put in a lot effort to suit all table and chart need.

Paul