topic Re: Re-create historical trend from current data in QlikView

Re-create historical trend from current data

kouroshkarimi — Thu, 06 Sep 2012 09:11:08 GMT

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!?

Re: Re-create historical trend from current data

kouroshkarimi — Fri, 07 Sep 2012 10:29:26 GMT

No one have any ideas?

Re: Re-create historical trend from current data

whiteline — Sat, 08 Sep 2012 16:11:48 GMT

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.

Re: Re-create historical trend from current data

kouroshkarimi — Mon, 10 Sep 2012 08:09:39 GMT

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?

Re: Re-create historical trend from current data

whiteline — Mon, 10 Sep 2012 08:59:22 GMT

Subtract two dates ?