Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Calculating Amount which are 30 days overdue

I'm trying to make the sum of amounts openstanding (AR) which are more than 30 days overdue.

I have the following formula , where Vervaldag = Due Date and BedragOpenstaand=Openstanding Amount

=Sum({<FactTypeId={5}, ">=$((date(today())-Vervaldag)>30) >}[_BedragOpenstaand])

Can any help.

Thx.

1 Reply
sunny_talwar
Not applicable

Re: Calculating Amount which are 30 days overdue

May be this

=Sum({<FactTypeId={5}, Vervaldag = {"=Date - Vervaldag > 30"} >} [_BedragOpenstaand])