Discussion Board for collaboration on QlikView Scripting.
I have a Table consist of total 9 column. I want to only display those company debt > 120days still not settle .( Only those long over due payment cusotmer )
Meaning if company their payment which is below 120days , i want to hide those row. ( Because they are consider good customer )
Hope some one can suggest to me what i need to add in my expression , in order to achieve my requirement.
Go to Solution.
Not entirely sure, but may be this?
Sum(Aggr(If(Max(TOTAL <COMPANY_PAY>aging_ar) > 120, Sum(total_ar)), COMPANY_PAY, aging_ar))
Wow you are supper good. it is correct.
Thank you very much.