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

[Anonymous]

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

[lakshmikandh]

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.