How to manage historical data in a bar chart - Qlik Community

Report Inappropriate Content · ‎2013-09-25

In a QVD file, I store data in incremental load: I store only news data or data which have been updated.

This is my QVD content:

I need a bar char with the count of Delay by INSERT_DATE, like the bar chart below:

But for ’20.09.2013’, I also want to take in consideration old orders (inserted at 16.09.2013)

For ’24.09.2013’, I want to take in consideration old orders (inserted at 16.09.2013 and at 20.09.2013).

So I tried to select the option to accumulate data. But if an order has been updated, the delay is counted twice.

For example the delay for this order is counted twice:

0000053307	A	16.09.2013	24.09.2013	>1	16.09.2013
0000053307	C	16.09.2013	24.09.2013	>1	20.09.2013

And I don’t want this.

So I’m expected this result:

Could someone tell me if it’s possible, and how to make it?

In advance thank you