topic Re: Month order in Chart in QlikView

Month order in Chart

Thu, 16 Oct 2014 12:09:24 GMT

Hi,

In Chart ( x-Axis) ,how to order the month in the order Jan,Feb,Mar for a year.Right now the chart show month in random order.

simondachstr — Thu, 16 Oct 2014 12:13:00 GMT

Go to sort and Sort by an expression like:

=Month(Date#(MONTH,'MMM'))

maleksafa — Thu, 16 Oct 2014 12:13:30 GMT

you have multiple options:

1) when loading the calendar table where you have the month names, add another field which is the number order, and in the chart sort by this number

2) when loading the month names load it as dual function with a number for sorting and in the chart sort by month name as numeric value

3) in your chart sort by expression, match(MonthName,'Jan','Feb','Mar','Apr'....)

Thu, 16 Oct 2014 14:26:49 GMT

Hi Martin ,

Thanks for the reply.

I have solved this in loading script using "Month(date) " conversion for date field & set the sequence for month.

Thu, 16 Oct 2014 14:28:45 GMT

Hi Malek,

Second option solved the query.