putting in date order

[#1]

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

[Anonymous]

Chris

How about converting them to QlikView date format ?

Then everything will be easier for you.

Best Regards,     Bill

[#3]

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

[Clever_Anjos · Accepted solution]

You can use this expression into your Sort Tab

Match(yourfield,'jan','fev','mar','abr','mai','jun','jul','ago','set','out','nov','dez')