2 Replies Latest reply: Jun 15, 2016 7:20 AM by Marcus Sommer RSS

    Period over period calculation

    Virendra Chawra

      In our current Requirement we want to design period over period data .


      our period code is like ;

      P1 to P13

      P1 start from 22/04/2015 to 19/05/2015 and P13 is 25/03/2016 to 21/04/2016...



      Now we are loading 3 years data and want to show the 3 Columns in KPI .


      (1) Current Period

      (2) Previous period

      (3) same period last year.




      Do we have any mechanism to do the same thing in the Qlikview script ...so that no need to calculate in set analysis...