I've worked with sample data. i.e.
LOAD MonthName(F1) as Year,F2 as Value;
LOAD * INLINE [
- Take dim as Year and exp as Count of value.
- Sort tab -> Check Y-Value and give ascending order (or) check exp and give exp as =MonthName(Year) select ascending order.
Hope it helps you.
Dont change [Month Year] to num.
u must be having a date field in your data model having value like 1/1/2012,1/2/2012 ,1/3/2012..............
that particular date field is required to be changed in number format so that that number sequence can be used by dual function to sequence your [Month Year] field
suppose ur date field name in data model is "Date1"
you can change ur date field i.e "Date1" to number format by
num(Date1) as DATE
Dual([Month Year], DATE) as [Month Year]
Just assume that F1 column is date field in u r data. Now design your chart according to my suggestions. For your reference i'm attaching my file. Otherwise please upload your sample file.
Hope it helps you
Community_13.qvw 148.8 K
There are no date fields in my data. I am extracting the Month/Year from the Filename.
The filename is structured as: "Data - Apr 2012.xls"
So in my script, I am extracting the "Apr 2012".
But the dual method works now and it is now sorting it in the correct order.
Many thanks for your help!