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.
How can i calculate previous 6 months Sales here in below script.
Note: In UI level i can achieve this, finding difficulty to calculate in script level .
use set analysis
maybe you need to adjust expression
I suppose we can not use set analysis in script. I want to calculate in Script as like Sum(Sales) which i did in script.
something like the attached?
note the set statement :
and use a calendar :
Understanding the Master Calendar (video)
if i want Current Month vs next 3 rolling month than what i need to do?
Month as Month_AsOf,
Month + 1 + IterNo() as Month
while IterNo() <= 3;
plus in IterNo instead of minus
and 3 instead of 6 in the while clause
see Calculating rolling n-period totals, averages or other aggregations for more details / suggestions
use if() in script level