4 Replies Latest reply: May 27, 2014 10:04 AM by Sandra Pérez RSS

    Periodic calculation


      Hi,

       

      I need to calculate periodic data in qlikview script.

       

      The issue is that data is stored in the data base in an acumulative way, so there is no periodic data in it. Therefore it is impossible to get periodic data directly from the data base.

       

      My idea is to create a new dimension in the script in which I can store the calculation of: (month X data) - (month (X-1) data), but I really don´t know if this is the best solution and even if it´s so, how to implement it.

       

      If anyone could help I would appreciate it¡