topic Re: Sorting for MonthYear in QlikView

Sorting for MonthYear

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm Having Dimension MonthYear in Which Values are like Feb2015, Mar2015, Feb2016, April 2016.

How can i sort them in Bar chart ?

Re: Sorting for MonthYear

Anonymous — Thu, 23 Jun 2016 07:14:15 GMT

Hi Satish,

You can order it by Expression, if you have a date associated: =Max({1} Date).

Regards!

Re: Sorting for MonthYear

tamilarasu — Thu, 23 Jun 2016 07:14:44 GMT

You can use below sort expression

=Date(Date#(MonthYear,'MMMYYYY'))

Re: Sorting for MonthYear

MayilVahanan — Thu, 23 Jun 2016 07:18:29 GMT

If you don't have any date column, try like below

LOAD MonthName(Date#(Month, 'MMMYYYY')) as Month Inline

[

Month

Feb2015,

Mar2015,

Feb2016,

Apr2016

];

And then sort by Numeric Value in Sort Tab

Re: Sorting for MonthYear

jonathandienst — Thu, 23 Jun 2016 07:20:51 GMT

If MonthYear is a valid QV date numeric, then sort numerically.

If MonthYear is a string, change your load so that it is converted into a date type.

LOAD

...

Date#(MonthYear, 'MMMyyyy') as MonthYear,

...

and then sort numerically.

Re: Sorting for MonthYear

susovan — Thu, 23 Jun 2016 07:22:38 GMT

Hi Satish,

Try this

Re: Sorting for MonthYear

Chanty4u — Thu, 23 Jun 2016 07:35:33 GMT

Create your Month_Year field as a date in the script: Date(MonthStart(MyDate),'YYYYMMM') as Month_Year. Then sort it by Numeric Value in the chart.

chk similar thread

RE:Bar Sort order

Re: Sorting for MonthYear

maksim_senin — Thu, 23 Jun 2016 07:39:39 GMT

Hi,

Also it's usefull to use Dual() function. Please refer to QV reference.

Best regards,

Maxim

Re: Sorting for MonthYear

ziadm — Thu, 23 Jun 2016 07:45:19 GMT

Load

Dual(Date(MonthStart(DateField),'YYYYMMM') ,DateField) as MonthYear