topic Re: Creating Daily Totals from an external data set in QlikView

Creating Daily Totals from an external data set

kevinstanfield — Thu, 11 Feb 2016 12:14:32 GMT

I have a dataset that's refreshed daily and I want to "database" the total value each day so I can track/trend and perform a comparison e.g. today v yesterday.

Can "Total Value" be calculated and stored each time the data is refreshed (daily) or would the data have to changed to accommodate this (there is a good reason for not doing this)

Thanks in anticipation

Kevin

Re: Creating Daily Totals from an external data set

marcus_sommer — Thu, 11 Feb 2016 13:52:32 GMT

I think this would be helpful for you:

Slowly Changing Dimensions

- Marcus

Re: Creating Daily Totals from an external data set

swuehl — Thu, 11 Feb 2016 14:20:00 GMT

I read this request more like a need for keeping a history file in QV for several snapshots of fact data, for example storing the current exchange rate on a day each day, so you get a history of rates.

- Create a QVW that queries your data source and read all current data.

- Aggregate the data to an appropriate level as needed

- append the data to a QVD that stores all snapshots with an additionally created 'snapshotdate' field

This QVD can then be used in any other application.

Do you have something like this in mind?