3 Replies Latest reply: Jun 5, 2017 4:15 AM by omar bensalem RSS

    Yearly WoW Comparison not working with set analysis

    Emergency Qlik

      Hi,

       

      Thanks in advance of any support on this.

       

      I would like to make a straight table in Sense which lists all weeks and has various measures in comparison

       

      As per below:

       

      This Week,

      Last Week

      Last 3 Weeks

      Same week last year.

       

      I have tried using set analysis but have no joy - it seems to only give me one value in each volume which is obviously not right.

       

      Many thanks

       

      WeekSumLast WeekRolling 3 weeksSame week last year
      1
      2
      3
      4
      5