Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Sorting Issue

Hi All,

I have filed Month has Jan, Feb, Mar.....Dec

Suppose if i select FEB selected value should be appeared last in filed(if gives sort order is Ascending) else first in field (if gives sort order is Descending).

My requirement is not change the place of value in filed. ex: if i select FEB it should appear 2nd place in field.

I hope you people understand my requirement.

Thanks you,

Regards,

Nihhal.

15 Replies
nihhalmca
Specialist II
Specialist II
Author

Hi Sorin,

You are talking about ApplyMap().

alkesh_sharma
Creator III
Creator III

I agree, Best way is to use DUAL function at script level and give each month a number and than sort through number

isorinrusu
Partner - Creator III
Partner - Creator III

No, not exactly.

You will find a QVW file attached.

The first table has month and month #. The second one only month. If you delete all sorting options in the selector that has the month value associated, the months will be automatically sorted according to the month number that you gave to each month.

The month selector withouth the number associated will not be ordered automatically.

Regards,

Sorin.

jagan
Luminary Alumni
Luminary Alumni

Hi Nihhal,

I think instead of using 12 Ifs use Match()


Match(Monthname, 'Jan', 'Feb', 'Mar', 'Apr', 'May'..........)


Regards,

Jagan.

nihhalmca
Specialist II
Specialist II
Author

Hi Jagan,

If i use match() in this case, sorting issue will be occurred. (please see at my posted question).

Regards,

Nihhal.

Not applicable

Use the following expression in

sort tab select dimension and select the expression in that expression write the code like this

=Wildmatch(Monthname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')