Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this? Check 'Suppress Zero-Values on the Presentation tab?
my QVW
Like this? Check 'Suppress Zero-Values on the Presentation tab?
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