Discussion Board for collaboration on QlikView Scripting.
sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))
I have a Pivot table 1 , which is working fine, i like to convert it to straight table.
=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), Dual('>121 ', 5)))))
I like to convert it into straight table. Hope some one can advise me.
I try on Table 2 it display null :-
The error is above expression.
Go to Solution.
Enclosed My QVW file.
If the expression no more syntax error , the first column of table 1 and 2 should be display same amount.
I haven't open your application. Condition should like below
sum(If(aging_ar >= 1 and aging_ar <= 30,total_ar))
Hi Paul Sir,
Hi P M
thank you very much it work fine now.