Displaying Rolling Last 12 Months in Order in Bar Chart

Thu, 12 Apr 2012 07:11:06 GMT

I'm trying to get a bar chart to display the rolling last 12 months in order.

My count is case code's where the start date is in the last 12 months.

My dimension is a calculated one of [start month] & [start year] which are calculated at script level as month([start date]) & year([Start date]).

I've tried sorting it in different ways but can't get it to sort in order. Any help would be greatly appreciated.

hic — Thu, 12 Apr 2012 08:47:49 GMT

Use the following expression instead:

=Date(MonthStart(Start),'MMM YYYY')

Preferably this should be added in the script, but it works fine as calculated dimension also.

/HIC

topic Displaying Rolling Last 12 Months in Order in Bar Chart in QlikView