6 Replies Latest reply: Dec 10, 2015 8:00 AM by Maurice Cornips RSS

    Accumulation through time

    Maurice Cornips

      Hallo,

       

      Does anybody have an idea how I can reach accumulation by the dimension Time/Periods in a formula that still works if I select specific time intervals from the master calendar fields.

       

      For example, if I select Year '2014' Qlikview will not show me the values for 2014, but the values until 2014 (including the values of the preceeding years).

       

      I want to compare the accumulated amount of particular investments with the revenue on this investment of a particular period.

      So when I select the period from the master calendar fields, I want to see the accumulated amount of the investment until that period and the revenue of that period.

       

      Regards,

      Maurice