Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.