topic Re: sorting month names in QlikView

sorting month names

rathnam_qv — Wed, 03 Sep 2014 12:13:05 GMT

Hi all,

i have a month field...that is not in a sort order...but ,i want to make it in proper sort order.

can anyone tel me!!!

PFA file

Regards,

Smiley.

Re: sorting month names

Anonymous — Wed, 03 Sep 2014 12:15:20 GMT

this is alphabetical order

do you have a datefield?

if yes, goto sort tab and enter month(yourdatefield) in ascending order

Re: sorting month names

maleksafa — Wed, 03 Sep 2014 12:18:40 GMT

i can think of two options.

1) in your script, when you are loading the month name use the dual function to add a number to the month name that way you will have for each month the proper month number, for example Jan will have 1 and March will have 3.

then in your chart go to sort tab and sort using numeric asc or desc.

2) go to sort tab in your chart, and under expression sort them using the match function:

match(Month,'Jan','Feb','Mar' ...)

Re: sorting month names

MayilVahanan — Wed, 03 Sep 2014 12:20:37 GMT

You can try these way:

Create a field in script by using

Num(Month(DateField)) as MonthNum;

Sort tab:

Expression : MonthNum

Sort:

Load Order: Ascending

If ur data is load in ascending order like Jan, Feb,....

Expression: match(Month,'Jan','Feb','Mar' ...)

Re: sorting month names

rathnam_qv — Wed, 03 Sep 2014 12:24:02 GMT

Hi Rudolf,

Thanks for your reply!!

The field MO_SHRT_NM is contains the values as Aug,Sep,Mar,...Dec.

this field i am using as dimention in a combo chart...there i am facing the sorting issue.

Regards,

Smiley.

Re: sorting month names

Anonymous — Wed, 03 Sep 2014 12:26:57 GMT

without knowing more about your app, i would suggest

to use an inline table with

[MO_SHRT_NM, sortnr

Jan, 1

Feb, 2

Dec, 12]

which connects to your MO_SHRT_NM and you can use sortnr in the sortfield

Re: sorting month names

MK_QSL — Wed, 03 Sep 2014 12:33:13 GMT

Go to Sort Tab....

Expression

Write below

Date#(MO_SHRT_NM,'MMM')

Re: sorting month names

ashfaq_haseeb — Wed, 03 Sep 2014 12:37:19 GMT

Hi,

Try below for sorting

Dual("Your Month Field",match("Your Month Field" ,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

Regards

ASHFAQ

Re: sorting month names

vinay_hg — Wed, 03 Sep 2014 12:38:53 GMT

in list box properties, sort it according to expression, i mean in formatting write the mmm/yyyy format for sorting. so sorting will happen based on the expression written for sort.

Re: sorting month names

rathnam_qv — Wed, 03 Sep 2014 12:39:16 GMT

Hi Malek,

canu please give me some example how to use dual function in this situation.

Regards,

Smiley.

Re: Re: sorting month names

maleksafa — Wed, 03 Sep 2014 12:59:55 GMT

here you go, in the script you will see that i am loading an inline table for the days (same thing applies for the month) they are in random order but have a number representing their proper order, and in the list box i am sorting based on numeric value.