Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's
dimension: MonthYear,manager
Expression:count(workers)
Issue:accumulated count of workers rolling 6 Months
example: Feb 2015 ->Under Manager ->40 workers(2008 to 2015 Feb accumulated Count)
here is the sample data
This blog post discusses a number of different ways you can accumulate values by bringing in a separate associated table. This includes MATs and other rolling periods:
http://www.quickintelligence.co.uk/qlikview-accumulate-values/
There is also an example app you can download that demonstrates the principles.
Hope that helps.
Steve