Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kouroshkarimi
Contributor III

Re-create historical trend from current data

Hi. Based on a list of invoices with open and closed dates I'm trying to create a 'snapshot' view as shown in the graph.bmp file below. It should display the age profile of the invoices as they would have been at the end of each month - e.g. at the end of May, show only those invoices that were open in May and how 'old' they were at the time.

All I have to work on is the current list of open and closed invoices to try and recreate the historical views (Invoice list.xlsx).

Can anyone help!?

4 Replies
kouroshkarimi
Contributor III

Re: Re-create historical trend from current data

No one have any ideas?

whiteline
Honored Contributor II

Re: Re-create historical trend from current data

If you constract .qvw and a table containing information "how 'old' they were at the time" (a number of months).

I think I can help you with a chart representation.

kouroshkarimi
Contributor III

Re: Re-create historical trend from current data

Thank you for your response, but my problem is I don't know how to create that information. How do I show that something was (for example) 3 months old in May, then 4 months old in June, then 5 months in July, but closed in August without making the table massive?

whiteline
Honored Contributor II

Re: Re-create historical trend from current data

Subtract two dates ?

Community Browser