Count items depending on the date until state of Item Changes

reivax31 — Mon, 11 Dec 2017 09:57:42 GMT

Hi Qlikers,

I'm trying to find a way to build a chart and and need your help for this one. I have a very simple set of data :

ID	DateType	DATE
1	Delivery Date	03/07/2017
2	Delivery Date	28/06/2017
3	Delivery Date	18/08/2017
4	Delivery Date	08/06/2017

The chart I want to build is to have the weeks as dimensions and one measure. What I want to measure is:

At each week I want to know the number of ID that are delivered. So I could use rangesum() but then I have my second condition that is not compatible with range sum(). Meaning that as soon as I have for a same ID an Autorized date then from that date this ID shouldn't be counted anymore as Delivered. But It has to show up delivered in my chart for all the previous weeks. So I tried something using Total and some conditions on the dates but it didn't work.

Thanks for your support

topic Count items depending on the date until state of Item Changes in App Development

Count items depending on the date until state of Item Changes