24 Replies Latest reply: Jan 29, 2018 8:12 AM by Sunny Talwar RSS

    Sum (sales) on a weekly scale but only sum one specific date in that week

    Xavier HEMELAAR

      Hi Qlikers,

       

      I created a chart with dimensions MyDate and measure sum(sales). I use alternative dimensions (my week, my month, etc...) table is like :

       

      MyDateMyWeekSales
      15/01/2018310
      16/01/2018311
      17/01/2018312
      18/01/2018313
      19/01/2018314
      20/01/2018315
      21/01/2018416
      22/01/2018417
      23/01/2018418
      24/01/2018419
      25/01/2018420
      26/01/2018421

       

      So right know when I switch my dimension to MyWeek I will have a sum of all my values in that week. I would like to only peek the max date of that week. So for week 3 the value should be 15  and for week 4 value is 21...

       

      Any idea ? thanks for your help