topic Re: Sorting doesn't work correctly in QlikView

Sorting doesn't work correctly

Tue, 25 Sep 2012 11:17:47 GMT

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)

Re: Sorting doesn't work correctly

Tue, 25 Sep 2012 13:08:32 GMT

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

Re: Sorting doesn't work correctly

Tue, 25 Sep 2012 13:15:53 GMT

Unfortunately that doesn't work

Re: Sorting doesn't work correctly

whiteline — Tue, 25 Sep 2012 13:30:33 GMT

Hi.

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

Re: Sorting doesn't work correctly

Tue, 25 Sep 2012 13:32:23 GMT

I mentioned State has been unselected it still exhibits that behavior

Re: Sorting doesn't work correctly

whiteline — Tue, 25 Sep 2012 14:15:13 GMT

Have you disabled the expression sort also ?

Re: Sorting doesn't work correctly

muniyandi — Tue, 25 Sep 2012 14:16:47 GMT

Hi,

Uncheck Order By Column in Presentation Tab.

Refer attachment file.

Re: Sorting doesn't work correctly

Tue, 25 Sep 2012 14:35:50 GMT

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

Re: Sorting doesn't work correctly

Tue, 25 Sep 2012 14:41:36 GMT

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.

Re: Sorting doesn't work correctly

whiteline — Tue, 25 Sep 2012 14:52:54 GMT

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

Re: Sorting doesn't work correctly

Tammy_Milsom — Tue, 25 Sep 2012 16:08:18 GMT

Try creating an inline table for that field only before it is loaded from your main data tables. For example if the field is called FinMonth do the following

Load * inline [

FinMonth

];

Then load main data tables and after that drop the inline table. On the listbox select Load Order on the sort tab with state and order by column unchecked.

Re: Sorting doesn't work correctly

MayilVahanan — Tue, 25 Sep 2012 23:08:56 GMT

Try with dual() function

Hope that helps..