Hi All!
I am working on a Qlik Sense dashboard for our accounts receivables
I have a table of invoice entries. This includes the invoice date. For my filters I use table calendar. Now I would like to have the age of the invoice calculated depending on the selected filter.
Suppose; invoice date is 01-01-2021, the selected filter is January 2021, the invoice is then 30 days old by the end of the month January If I change the filter to February 2021 then the age should change to 58 days.
In this way, for each invoice the age must be calculated so that I can categorize the invoices to different groups.
How can I achieve this?
Thank you very much in advance!