Discussion Board for collaboration related to QlikView App Development.
Hi, I want to plot a graph with month year as a dimension. The expression I want to show is the last twelve months sales. So for Jan2011 I want to show sales from Feb 2010 to Jan 2011 and so on.
Any pointers gratefully received !
Easiest way is to make it a calculated dimension
if(month_year>=time_period_begin and month_year<=time_period_end,month_year)
Supress when value is null
see the attached file
hope this helps