Discussion Board for collaboration on QlikView Scripting.
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