Discussion Board for collaboration related to QlikView App Development.
Hey ,
i have 3 yrs data(2010,2011,2012) ..i want 12 months values in each bar..ex:
if i select Dec 2012 then on first bar i want i.e
Mar2010 (i want starting 12 months data from Jan2010 -Mar 2010) and in next bar
Apr2010(i want jan2010-Apr2010)
-
-
-
Dec2010(Jan2010-Dec2010)
Jan2011(Feb2010-Jan2011)
Please read these two documents:
Then read this blog post:Accumulations
Try this:
RangeSum(Above(total Sum(Sales) , 0, 12))
Or else 12 steps accumulation
Hope helps,
Thanks,
Hirish