Capturing Trends

[mrdaveBT]

I need to capture a daily volume snapshot from a data table I am connected to in Oracle, so that I can show a trend.

Basically I need a table that contains a count of jobs in the Oracle data set, captured at midnight each night, and written into a table that will reside in Qlik Sense .

I think I will do this by creating an app that will generate the SUM calculation, and write to a QVD, by adding a row to it each night using a scheduled reload task on the app.

Can anybody point me in the right direction of some guidance, or point me to how to get started?

[morgankejerhag]

Make a script that calculates the correct values in a table. Store the table with a postfix with the date. Make an app that reads alls files.

Let vDate = text(date(today(),'YYYYMMDD'));
store Table into Table_$(vDate).qvd (qvd);

Some other app:
Load * from Table_*.qvd (qvd);

Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se