Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Any quick way of ensuring on a graph data is orted in month order? None of the normal sorting options (frequency, load order) enable it to show this way.
Months are text and not in date format.
Cheers
Chris
You can use this expression into your Sort Tab
Match(yourfield,'jan','fev','mar','abr','mai','jun','jul','ago','set','out','nov','dez')
Chris
How about converting them to QlikView date format ?
Then everything will be easier for you.
Best Regards, Bill
Load an Inline table with MonthID and MonthName like
MonthID MonthName
1 Jan
2 Feb
3 Mar
....
make sure MonthName and the other field joins and then sort it by MonthID
You can use this expression into your Sort Tab
Match(yourfield,'jan','fev','mar','abr','mai','jun','jul','ago','set','out','nov','dez')