Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to hide row that payment clear before 120 Days ?

Hi All

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.

Paul

1 Solution

Accepted Solutions

Re: How to hide row that payment clear before 120 Days ?

Not entirely sure, but may be this?

Sum(Aggr(If(Max(TOTAL <COMPANY_PAY>aging_ar) > 120, Sum(total_ar)), COMPANY_PAY, aging_ar))

3 Replies
paulyeo11
Valued Contributor II

Re: How to hide row that payment clear before 120 Days ?

my qvw

Re: How to hide row that payment clear before 120 Days ?

Not entirely sure, but may be this?

Sum(Aggr(If(Max(TOTAL <COMPANY_PAY>aging_ar) > 120, Sum(total_ar)), COMPANY_PAY, aging_ar))

paulyeo11
Valued Contributor II

Re: How to hide row that payment clear before 120 Days ?

Hi Sunny

Wow you are supper good. it is correct.

Thank you very much.

Paul

Community Browser