topic Re: Sorting month field in QlikView

Sorting month field

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

Hi all

Please let me know how can I sort field named 'Month' having values as follows:

Month

Feb

Aug

Jan

May

Nov

July

I want to display values 'Month' field as:

Month

Jan

Feb

May

July

Aug

Nov

Thanks in advance.

Regards,

Re: Sorting month field

Chanty4u — Fri, 13 Apr 2018 05:55:23 GMT

where you want this? front end listbox ? bar chart?

Re: Sorting month field

Chanty4u — Fri, 13 Apr 2018 05:56:43 GMT

try to do like this

Try this Expression:

wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Re: Sorting month field

ahmar811 — Fri, 13 Apr 2018 06:02:08 GMT

Hi,

If you try to sort Month in some chart you just put sorting condition into Chart Properties->Sorting->Expression

wildmatch(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov,'Dec')

If you want to sort from load script implement below condition

dual(wildmatch(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov,'Dec'),Moth) as Month

and sort by Month should be used

and above expression should be in Ascending order;

Regards

Ahmar

Re: Sorting month field

Anonymous — Fri, 13 Apr 2018 06:02:53 GMT

Thanks for reply.

I want to do this in a table box. there I have several fields, one is 'Month' field.

Re: Sorting month field

Anonymous — Fri, 13 Apr 2018 06:06:22 GMT

Thanks for replying.

Do I need to include all 12 months in the expression or just above listed months, in ascending order.

Re: Sorting month field

shiveshsingh — Fri, 13 Apr 2018 06:21:22 GMT

Can't you simply sort the table box based on month?

Re: Sorting month field

keerthika — Fri, 13 Apr 2018 06:28:32 GMT

Hi,

If you want to sort month in list box ,create list box with field select Month and in sort tab enable Expression and use

=only({1}Num(month(date#(Month,'MMM'))))

and select Ascending in expression dropdown.

Regards,

keerthika

Re: Sorting month field

Anonymous — Fri, 13 Apr 2018 06:45:39 GMT

That's what my question is. if I try Tablebox properties---> Sort tab----Select Month field then what are the option to sort month field.

I am sure we cant do it by setting Text/Number in ascending and descending order. Because this does not apply to Month field values.

Re: Sorting month field

shiveshsingh — Fri, 13 Apr 2018 06:48:05 GMT

ok, choose expression wise sort and put =only({1}month(date#(Month,'MMM')))

Re: Sorting month field

shiveshsingh — Fri, 13 Apr 2018 06:48:45 GMT

and don't forgot to promote month in sort tab

Re: Sorting month field

baarathi — Fri, 13 Apr 2018 06:56:39 GMT

Go to sort tab, select sort by expression and give num(month(datefield)) and ascending at top

Re: Sorting month field

sasiparupudi1 — Fri, 13 Apr 2018 12:34:27 GMT

try this as the sort expression

Date#(Month,'MMM')

Num(Month(Date#(Month,'MMM')))