sorting month

[#1]

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. 😞

[senpradip007]

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').

[anbu1984]

Check this app

[#4]

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

[jagan]

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.

[#6]

hi it works.. thanks alot for ur feedback 🙂

[anbu1984]

Pls close the thread, if your queries are answered

[ychaitanya]

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

[MarcoWedel]

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