topic Re: month wise sorting - Apr - March Barchart in QlikView

month wise sorting - Apr - March Barchart

vikasmahajan — Wed, 17 Oct 2012 04:33:47 GMT

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

Anonymous — Wed, 17 Oct 2012 04:42:01 GMT

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 — Wed, 17 Oct 2012 05:24:25 GMT

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 — Thu, 18 Oct 2012 07:55:08 GMT

Dear Tom

Thanks

vikasmahajan — Thu, 18 Oct 2012 07:56:21 GMT

Thanks