6 Replies Latest reply: Sep 18, 2017 9:56 AM by Xavier HEMELAAR RSS

    Accumulation with limitation

    Xavier HEMELAAR

      Hi Qlikers,

       

      In one of my charts I would like to do an accumulation but then at a certain point I would like to stop the chart

       

      So my dimension is a date (CanonicalDate) and my measure expression (Validated) is:

       

      rangesum( above( Count({$<DateType={'AvailabilityDate'}>} IDNumber),0,rowno()))

       

      Not working Example.png

      As you can see my measure called Validated goes futher than a specific date that I stored in a variable vFirstDayOfWeek. What would be the expression for my measure in order to stop displaying the bar chart after my variable?

       

      Also, as you can see for some dates I have no value, so no bar in my chart. What would be the expression in order to have a bar displayed for each day? With the line chart I dont have the problem because the lines are automatically linked. My table are build has explained in this topic Canonical Date

       

      The expected result is:

      Example.png

       

      Thanks for your help!