8 Replies Latest reply: Sep 25, 2012 11:53 AM by Vinay Bangari RSS

    Rolling 12 month values

      Hi there,

       

      I've just started using Qlikview and I need to sum values by year and month over a 12 month period.So for example I have data for June 2012 and I want to sum this value and previous 12 months (so going back to July 2011). Can anyone tell me how I can do this? I saw a post on here where the guy made changes to the date info script. In my code  I just have a list of default set statements for the date etc followed by a load statement.

       

      Many thanks

       

      Adrian