topic Re: sorting month in QlikView

sorting month

Thu, 06 Nov 2014 06:04:13 GMT

how to sort month names in ascending order in qlikview .Can anyone help me to sort months in a proper order..i tired in expression also but not sort month. 😞

Re: sorting month

senpradip007 — Thu, 06 Nov 2014 06:12:00 GMT

Do you want to sort alphabetically or financial month wise or calender month wise?

For alphabetic you just sort it as Text (A-Z).

For financial month you try with Match(Month, 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar').

Re: sorting month

anbu1984 — Thu, 06 Nov 2014 06:12:02 GMT

Check this app

Re: sorting month

Thu, 06 Nov 2014 06:20:57 GMT

Hi Amjad

There are two ways through which you can sort it,

1) Using sort A-Z selection under sort tab ,that comes when you go to the properties of your chart.

2)The second option is by using expression option and writing an If condition like

if(month=jan,1),if (mon=feb,2)......likewise

hope you must have got the idea.

Thanks

Re: sorting month

jagan — Thu, 06 Nov 2014 06:24:22 GMT

Hi,

If you are arriving month in script like below then you can specify Properties -> Sort-> Numeric

LOAD

Month(Date) AS Month

FROM DataSource;

Regards,

Jagan.

Re: sorting month

Thu, 06 Nov 2014 06:32:52 GMT

hi it works.. thanks alot for ur feedback 🙂

Re: sorting month

anbu1984 — Thu, 06 Nov 2014 06:37:16 GMT

Pls close the thread, if your queries are answered

Re: sorting month

ychaitanya — Thu, 06 Nov 2014 06:49:45 GMT

In Sort Tab you can use the following expression

Only ( {1} Match(Month,'Jan,'Feb',Mar','Apr','May','Jun','Jul','Aug','Sep'.'Oct','Nov','Dec')

This will help you the way you wish .. may be from Jan- Dec or Apr-Mar...

Please close the thread by marking Helpful and answered .

Thanks

Chaitanya

Re: sorting month

MarcoWedel — Thu, 06 Nov 2014 11:53:17 GMT

Try to create the month field using the Month() function in the script.

Doing so, it will be sorted chronologically without any additional sorting expression.

please provide sample app/data to demonstrate.

thanks

regards

Marco