topic Problem with sorting! in QlikView

Problem with sorting!

Wed, 23 May 2012 13:11:43 GMT

Hey!

Let say i have a worked hours, and payed hours in execel as two collums. Lets also say i have a date collum with the date, for example, 2011-01-31, lets also say that i have a collum month.

Worked hour Payed hours Date Month

4 4 2011-01-02 Jan

5 3 2011-03-31 Mars

6 6 2011-01-31 Jan

7 5 2011-02-24 Feb

Now i want to plot this, and thats no problem, i use the Moth as dimention. And use tree functions, sum(Worked hour), sum(Payed hours).

Then I make a list with the dates and month so i can choose between them.

My problem is how to sort the x-axis of the diagram and the month list. I want ofc Jan,Feb,Mars. But i get Jan, Mars, Feb.

Quite hard to explain but I hope someone understans. (I use the loadorder from execel)

Problem with sorting!

kji — Wed, 23 May 2012 13:50:36 GMT

You can put a 1 column table at the beginning of the script with the Months in your preferred order and then use the "Load Order" sort option.

LOAD * INLINE [

Month

Jan

Feb

Mar

...

];

Problem with sorting!

Wed, 23 May 2012 14:05:19 GMT

Sweet, so the load order takes the first one, sweet. Now it works!

Problem with sorting!

manisha_uit — Wed, 23 May 2012 14:09:34 GMT

Hi,

Go to the chart properties -> Sort

Select expression in the sort order and write the following code there:

=Match(Month, $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

This will sort your month in the proper order

Thanks

Manisha Choudhary

Re: Problem with sorting!

Fri, 10 Aug 2012 06:36:52 GMT

Hi Johan,

Thanks for the tip about sorting months. After creating INLINE, what's next?

Thanks.

Don