Cumulative graph based on different dates

[Martijn1]

Hello,

I want to show a cumulative result in a graph over time, however I can't manage it. I hope you guys know a way.

Table 1: Data

Graph 1: Cumulative result

The data (See attached picture):

• Item: Unique ID
• Load_date: The moment at which the data was uploaded (so from 1-1-2019 until 1-8-2019 I uploaded the data monthly, which is a dump not a delta)
• Status: Tells something about the item and is a derived column. Prognosed, means that the item will be deleted in the future (based on the moment of Load_date)
• Date_deleted: Date at which the item will be deleted or is deleted.
• Value: The value corresponding with the item

The problem I face is the following:

The prognosed values are values which I want to add up at the moment which they are expected to be deleted, not at the moment at which they get the status of "Prognosed".  To do so, I need to combine the 2 dates I guess (Load_date and Date_deleted).  But I have no idea how i do that, so that I still can use it as a timeline (x-axis) in my graph.

Do I need a master calendar table for that? Or is there a different solution?

Thanks

[Martijn1]

Hi,

sorry for the delayed reply. I need some time to create this. I know what to do, I think. But it will take me some time to write the code, since I am new to qlik Sense.

Nevertheless, thanks for your effort and input!

kr

Martijn