month wise sorting - Apr - March Barchart - Qlik Community

vikasmahajan · ‎2012-10-17

Dear all

Find attachment of bar chart picture i want sorting on month's from april to march (Month no)

I am using qv11 version and months are put in cyclic drill.

How do I sort it.

Thanks

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2012-10-17

So you want to sort the months from Apr - Mar, 1-12.

Load a table using Month and MonthSort values:

Load * Inline [

Month, MonthSort

Apr, 1

May, 2

etc...

Mar, 12 ];

Then in your chart, set the dimension to be sorted by expression, using MonthSort

thomas_skariah · ‎2012-10-17

Hi Vikas,

You can use the following expression on prop-> sort->Expression

=wildmatch(Month,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

Hope it works for you.

Regards,

Tom

vikasmahajan · ‎2012-10-18

Dear Tom

Thanks

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2012-10-18

Thanks

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.