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

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?

Community Browser