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.
In the chart below the expressions you will have no accumlate , full accumlation & accumlate . Enable Accumlate and give number of steps as 12 because rolling 12 months. see the screen shot for your reference. Hope that helps.