Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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):
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
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