This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Happy new year, hope it was a good break for everyone
I have a query around rolling 12 months. I have seem many calculations around 12 months from today, however I am looking for an additional piece of calculation.
Say I have months from Dec 15 all the way back Jan 13.
Then whenever I select one of those months in the range, I have the calculation to show me the current 12 months, however I also require the previous 12 months from there.
So if I select Dec 15;
So if I select Nov 15;
I have the following calculation, which works for the Current rolling 12 months, but can't see to get the Previous one working.
Any ideas, would be much appreciated.
You can create Rolling 24 months in the script level.
Please check below document.
Calculating rolling n-period totals, averages or other aggregations
In your expression make sure that MonthStart function return the same date format like Period_Start_Date.
The other method is create MonthNumber field having 1, 2, 3,4, 5, ....etc for Month ascending order & try below expression.