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.
We have sales revenue for each month and the user like to have a comparison with rolling average of previous 3 months with the actuals. Can anybody suggest how to do this.
Actuals Rolling Avg
6000 5500 ((5000+6000)/2)
4000 5000 ((5000+6000+4000)/3)
8000 6000 (6000+4000+8000)/3)
Thanks and Regards,
here are an example.
View solution in original post
see QV help for rangeavg (above(Sum(x), 0, 3) as example.