4 Replies Latest reply: Aug 8, 2011 6:04 AM by anas.benj RSS

    Simulate date

      Hi everyone,

       

      I have data samples over months (Jan to July).

       

      [Jan,1

      Feb,2

      Mar,3

      Apr,4

      May,5

      Jun,6

      Jul,7]

       

      I also know the december value

       

      [Dec, 20].

       

      How do i calculate (simulate?) data from July to December with :

       

      Aug = (Dec - Jul)/5

      Sept = (Dec - Aug)/4

      Oct = (Dec - Sept)/3

      etc.

       

      I have no idea how to do it in qlikview

      Many thanks for your help