Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I hope someone could help me with my problem.
I have some data, that i need to get into QlikSense and create some visualizations. First i only need a bar chart.
I have two columns with dates in it. One is "Dispatch date" and other is "On Stock" date. What i need to do is to Sum values in a column with "On Stock" date with the values that have "Dispatch date" greater than "On Stock" date. But this value also needs to have added values from previous "On Stock" date if the "Dispatch date" is greater than current "On Stock" Date.
For example: In the below picture with data on the right side you have column example with values. So 05.2020 would sum values from "Dispatch" 06 & 07 rows to the 05 Column in "On Stock" which adds up to 1300, but column 06.2020 would only sum the values from 07 Dispatch row to 06 On Stock column, which would add up to 1100.
Any help on this problem would be greatly appreciated.
