Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a QV dashboard that has several xls files as a source.
The xls files are various status reports of my project which are updated on a weekly basis.
What I would like to do is keep the history per week. Meaning that I would like to store some KPI's per load.
Does anyone know of an easy way to do this?
For example:
I load the file status.xls on 03/07 and have that KPI_A=250.
I load the files status.xls (which is updated) on 10/07 and have that KPI_A=500.
How can I store the KPI_A of 03/07 to be able to track my progres?
Thanks in advance!
Kind regards,
Jens
If the KPI is stored in a variable then load it in a table and store it in qvd format.
Ex:
First time you have to create a History file
Let KPI_A=500;
TableKPI:
Load
'$(KPI_A)' as KPI
Autogenerate 1;
Store TableKPI into TableKPI.qvd (qvd);
Next time
Let KPI_A=500;
TableKPI:
Load
'$(KPI_A)' as KPI
Autogenerate 1;
Concatenate(TableKPI)
Load * from TableKPI.qvd (qvd);
Store TableKPI into TableKPI.qvd (qvd);
This will maintain the history.
Hope this will help
Thanks for the response Arasu.
The problem is that I have a very high number of KPI's that I would like to store (almost all the data that I load).
So I was wondering if it would be possible to store these upon loading (in bulk) and adding the load date to be able to generate some history graphs from it afterwards.
Kind regards,
Jens
It seems to me that you want to use an incremental load, i.e. loading only the newest data from source, but accessing also historic data. There is a description in the Manual of how to do something like this and also a quite nice working example in the QV cookbook (which I can recommend anyway):
http://robwunderlich.com/downloads/
Hope this helps,
Stefan