8 Replies Latest reply: Jan 4, 2016 4:12 AM by Sangram Reddy RSS

    Another question about date fields in QlikSense

      I have a data set with a Date field and a field ‘VolumeConsumed’ per date.

       

      DateStamp   VolumeConsumed

      12/20/2015 - 40

      12/21/2015 - 50

      12/22/2015 - 50

      12/23/2015 - 50

      12/24/2015 - 50

      12/25/2015 - 40

      12/26/2015 - 30

       

      I am trying to make a calculation and determine

       

      1. Sum of VolumeConsumed in the past 3 days (in the example it is 120 (50+40+30)

      2. Average VolumeConsumed in past 3 days (40)

      3. The difference between average VolumeConsumed in past 3 days and Average VolumeConsumed (40 vs 44.3)

       

      Thanks

      Bjarke