0 Replies Latest reply: Jan 31, 2018 11:32 AM by Joanna Seldon RSS

    show specific dates qlik sense

    Joanna Seldon

      Hi

       

      I am using qlik sense

       

      I have the following set analysis

       

      SUM({$< WeekCommencingMonday= {"$(='>=' & WeekStart(Max(WeekCommencingMonday),-8) & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, ID={'1', '2', '3'}>}Value)

       

      in the data load I have this to work out week commencing

       

      Date(WeekEnd("Date", 0, 1), 'DD/MM/YY') as WeekCommencingMonday

       

       

      on the chart I am trying to restrict the data to 8 weeks

       

      it shows all the dates going back as far as 2016 along the x axis.. I only want it to show the last 8 weeks

       

      also as well, if there is no data for e.g 01/01/2018, I still want it to show this date along the x axis

       

       

      I do have an additional calendar script that value data is linked to as well, making sure all dates are in the data load

       

      please help