topic Sort months in QlikView

Sort months

manisha_uit — Thu, 25 Aug 2011 10:26:22 GMT

Hi everyone,

Can anyone help me to sort months in a proper order.

Thanks

Manisha Choudhary

Sort months

jonathandienst — Thu, 25 Aug 2011 10:29:27 GMT

The Month() function returns a dual value with the month name as the text and the month number (1-12) as the value. This will sort in calendar order.

LOAD ...

Month(date) AS Month,

...

Hope that helps

Jonathan

Sort months

its_anandrjs — Thu, 25 Aug 2011 10:37:00 GMT

Hi,

Yes when ever you sort the value it is sorted in the proper order by desceding or ascending order but if you want to sort it alphabetical or Numerical value it is sorted in that order by selecting in the sort menu option in properties.

Regards

Anand

Sort months

Sokkorn — Thu, 25 Aug 2011 10:37:57 GMT

Hi Manisha Choudhary,

Can you explain more on your requirement? Or you can upload your file for more details on your requirement.

Regards,

Sokkorn

Sort months

its_anandrjs — Thu, 25 Aug 2011 10:40:14 GMT

Hi,

Please confirm in any object you want to sort the value of months or by fetching the value you want to sort the value.

Regards,

Anand

Sort months

manisha_uit — Thu, 25 Aug 2011 10:43:01 GMT

Hi,

Thanks for your quick responses.

Let me explain what i want to do.

I have a list box containing months which is sorted in alphabetical order.

I want it in proper order as: Jan Feb Mar Apr ......

Thanks

Manisha

Sort months

its_anandrjs — Thu, 25 Aug 2011 10:47:06 GMT

Hi.

For sort it in proper order goto

Properties -> Sort -> Check Mark Expression -> select Ascending or Desceding -> or in the below text box type month column field.

By this you can get sorted month in proper order.

Regards

Anand

Sort months

manisha_uit — Thu, 25 Aug 2011 10:53:51 GMT

Hi Anand,

Thanks for your reply.

But this doesn't seem to work correctly.

Any other solution...

Thanks

Manisha

Sort months

its_anandrjs — Thu, 25 Aug 2011 10:56:22 GMT

Hi,

Do you have any small sample file if so please provide to me.Or if you sort the moths by expression so only Expression shold be check mark you check this or not.

Reagrds

Anand

Re: Sort months

its_anandrjs — Thu, 25 Aug 2011 11:08:45 GMT

Hi,

Please check you select this or not in the sort menu.

Reagrds

Anand

Re: Sort months

Sokkorn — Thu, 25 Aug 2011 11:09:36 GMT

Hi Manisha,

Right Click on List Box --> Perperties --> Sort tab --> Check Expression --> Paste this code : =Match(MONTH, $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

Hope this help you.

Note: MONTH is your month field.

Check attached file.

Regards,

Sokkorn

Sort months

manisha_uit — Thu, 25 Aug 2011 11:13:10 GMT

Hi Sokkorn,

Thanks for your reply. Its working fine.

Thanks

Manisha

Re: Sort months

its_anandrjs — Thu, 25 Aug 2011 11:20:45 GMT

Hi,

It is depending on the load from where and what is the data type it is purely converted to original ones or not if it ls load from excel it shold be different.

See the attached sample one.

Reagrds,

Anand