Sorting doesn't work correctly

[#1]

I have a scenario where I display a multi-select box containing this data:

1 - Jul

2 - Aug

3 - Sep

4 - Oct

5 - Nov

6 - Dec

7 - Jan

8 - Feb

9 - Mar

10 - Apr

11 - May

12 - Jun

I sort it with this expression (ascending): =num(trim(left(Financial_Month,2)))

It's divided into 6 columns so it'll display in this order:

1 | 3 | 5 | 7 | 9 | 11

2 | 4 | 6 | 8 | 10 | 12

However, as soon as I select something (anything, let's take 1 - Jul for example). It will grey out everything and sort it like this:

1 | 2 | 4 | 5 | 8 | 10

6 | 3 | 7 | 11 | 9 | 12

Which totally confuses the end-user who now has to go and look for a specific number/month combination.

I've turned of "State" sorting (which defaults to Auto Ascending), but still this happens.

I need to solve this issue ASAP as the end-user is very irratated by this behavior (nevermind that the normal web-view vs the IE plugin works entirely different and the user required IE Plugin just to do a multi-select, where in Chrome you can do it easily. Unfortunately IE is the only supported browser here)

[#2]

Try to sort by the expression:

Match(Financial_Month, '1-Jul','2-Aug','3-Sep','4-Oct','5-Nov','6-Dec','7-Jan','8-Feb','9-Mar','10-Apr','11-May','12-Jun')

[#3]

Unfortunately that doesn't work

[whiteline]

Hi.

I think you could just uncheck 'Sort by State' and only check 'Sort by Text' (uncheck the expression sort also).

[#5]

I mentioned State has been unselected it still exhibits that behavior

[whiteline]

Have you disabled the expression sort also ?

[muniyandi]

Hi,

Uncheck  Order By Column in Presentation Tab.

Refer attachment file.

[#8]

That would defeat the purpose of it sorting per number added to the string value, so you'll get a sequence like 1, 10, 11, 12, 2, 3, 4 etc

[#9]

I replicated it exactly as you put it (excluding the data source) and it's not working at all. Yours works perfectly though.

Ugh. I hate how the previous QV guy did things. I'll re-look the data tomorrow and optomize accordingly. This could have been done with calculated fields instead of putting it in the data itself and depending on QV to handle things.

Wish I could include a qvw for you guys, but unfortunately the data is sensitive and I suspect if I did what you did (the source) it would work immediately.

[whiteline]

It's strange but text sorting works well. Did you really try it ?