Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kevinstanfield
New Contributor III

Creating Daily Totals from an external data set

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Creating Daily Totals from an external data set

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?

2 Replies
Highlighted

Re: Creating Daily Totals from an external data set

I think this would be helpful for you:

Slowly Changing Dimensions

Slowly Changing Dimensions

- Marcus

MVP
MVP

Re: Creating Daily Totals from an external data set

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?