4 Replies Latest reply: Oct 11, 2013 4:26 AM by David Reis RSS

    Running Sum on Load Script

      Hi all,

       

      I'm having an issue where i'm not finding an solution for it. The challenge is the following:

       

      • I'm loading for 1 qvd each day from the database. (i'm using this approach because to calculate each day on the database is quite an heavy loading.)
      • I load all the QVD to a table directly which is quiet fast.

       

      The problem resides between those two steps. I needed to create an new measure that would be an running sum of some of those columns.

       

      ex:

       

      Dayvaluerum_sum
      133
      258
      3210

       

      I've loaded all the qvd's and tried to make one new column with an formula from the resident table but without success.

      I'm new to Qlikview so i'm probably missing some part.

       

      Thanks,