12 Replies Latest reply: Jul 20, 2017 2:09 AM by Sada Siva RSS

    Set Analysis on different time period in the same table

    Giulio Andrea Toscano

      Hi All,

       

      I am facing the following problem:

       

      I have different products in my dataset with different launch date for instance:

       

      ProductLaunch Date
      Bread03/06/2017
      Pasta14/06/2017
      Biscuit23/06/2017
      Pizza04/07/2017

       

      Now I want to start some analysis by putting in the same table each product and comparing the performance of products in their first 7 days. I am able to perform a set analysis just on fixed interval of time (i.e. with a set analysis on YearWeek field) but not in this case where I just want to compare the performance of products in their first 7 days. I have tried with loading the above table and by making a P() set analysis in the field "Date", but seems not working.

       

      Attached are some test-Data.

       

      the following table (based on the attached test Data) is my target to reproduce in Qlik:

        

      Launch DateRevenue
      Bread03/06/2017280.5
      Pasta14/06/2017201
      Biscuit23/06/2017114
      Pizza04/07/2017816.5


      Any help would be really appreciated,

       

      thanks in advance.

       

      Giulio