Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
kolakiran
New Contributor II

How to do Ageing bucket calculations based on backdated entry in Qliksense?

How to do Ageing bucket calculations based on backdated entry in Qliksense?

Example:

I have a Report called Ageing  buckets with Back Dated entry...

In Sheet area I have a filter called Date, Based on Selected date in Date filter Buckets should update in Sheet accordingly, and show outstanding days as well.

i have a fields like Year, Month,Day,Invoice date , Due date, Effective date

Thanks in Advance

Regards

Kiran

1 Reply
lakshmikandh
Valued Contributor II

Re: How to do Ageing bucket calculations based on backdated entry in Qliksense?

Assign that selected date to variable, Create the bucket dimension based on the datecolumn-variable in expression so this will dynamically change based on the date selection.