0 Replies Latest reply: Dec 11, 2017 4:57 AM by Xavier HEMELAAR RSS

    Count items depending on the date until state of Item Changes

    Xavier HEMELAAR

      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