rolling months not gives the right values

[sr_qlikview]

I am using the below expression for rolling months

sum({<Year=,Month=,Monthserial={"<=$(=Max(MonthSerial))>=$(=Max(MonthSerial-6)) "}>}amount)

monthserial- is sequence auto number starts from 1 (least month) ..ex: if data is for 2012 and 2013, starts from 1(jan 2012) to 15 (march 2013)

dimension is 'Month'

it gives the chart but the trend is wrong. it is giving in random order

but if i use the 'Monthserial' dimension it gives the right way.

How should i handle this. Unfortunately i can not upload anything to web because of my comp restrictions.

[#2]

Hi,

Is the month field a date format? or is a text?

If is a number you can order the Month in "Order" sheet, properties chart.

Regards,

Ricardo

[sr_qlikview]

month is month name, but my target is to have this expression in a straight table mini chart ... thought i should get this right in regular chart first.

My straight table dimensions are completely different ( region and team ) and different expression for ytd,mtd and then the rolling chart ...

sorry if i confused you.

how does the minichart works, what dimension does it consider ?

[#4]

If the month is the month name, so QlikView order alphabetic.

First, try this:

Month(DateField) as Month

This function returns the month name like format, but is a number, so you can orden the month correctly in your chart.

Regards,

Ricardo

[#5]

Another thing you can try is simply making your expression Sum(Amount) and then in the presentation tab set your Max Value equal to the number of months you want to view (like 6 for 6 months).