topic Re: Track changes from one refresh to the next in QlikView

Track changes from one refresh to the next

Tue, 02 Aug 2016 17:06:23 GMT

is it possible to track changes from one refresh to the next?

We are using the web enterprise version and direct connect.

The data base we are connecting to is like a temporary file. data is added and removed on a daily basis. But we only want to refresh data weekly.

Re: Track changes from one refresh to the next

sunny_talwar — Tue, 02 Aug 2016 17:07:59 GMT

For comparison, you will need to save an archive of your data. This can be done each day while reloading the application, but will make your application really big

Re: Track changes from one refresh to the next

Clever_Anjos — Tue, 02 Aug 2016 17:24:47 GMT

You want to compare row by row?

You can export some main KPI´s to text files on each reload and load them on next load comparing the results

Re: Track changes from one refresh to the next

Tue, 02 Aug 2016 17:26:14 GMT

how would I set up an archive data? Can it be done automatically at each refresh?

Re: Track changes from one refresh to the next

sunny_talwar — Tue, 02 Aug 2016 17:32:23 GMT

Yes you can. You just need to do a store statement with date in it

LET vArchiveDate = Date(Today(1), 'DD-MMM-YYYY');

LET vToday = Num(Today(1));

ArchiveTable:

LOAD *,

Date($(vToday)) as ArchiveDate

Resident FactTable;

STORE ArchiveTable into ArchiveTable_$(vArchiveDate).qvd;