topic Re: Sorting Issue in QlikView

Sorting Issue

mphekin12 — Wed, 12 Sep 2012 20:20:42 GMT

I have a list box that is sorted by State and then by Text A -> Z. When I open the .qvd directly, the sort is working correctly. When I publish the qvd and open it via 'Open in Sever', sometimes the list box is only sorted by Text A - Z, the state is totally being ignored. If I make a copy of this object and paste it in the dashboard without making any changes to the properties, the pasted version is sorting by State and then by Text A - Z.

Has anyone else experienced this? Does anyone know of a work around? I am using QV 11.

I have included a screen shot of the two list boxes. The one on the left is the original and the one on the right is the copy.

Thank you!

Re: Sorting Issue

mphekin12 — Thu, 13 Sep 2012 14:01:29 GMT

FYI, it looks like I might have found a solution. I changed the State sort criteria from 'Auto Ascending' to 'Ascending' and so far the sorting seems to be working correctly on the server.

Re: Sorting Issue

Mon, 03 Dec 2012 09:15:03 GMT

Personally, I think there is a bug in the Auto Ascending on State (I'm using QV11 SR1).

Most of my list boxes are Auto Ascending and until recently, they behaved as expected.

However, recently they sometimes display with all the available selections at the top and sometimes with them scattered throughout the long list of values.

I can't figure out why this has happened, but it has affected all my documents - both on the server and on the desktop. The fix is to change to Ascending, but this isn't good enough and I hope Qliktech investigates this issue.

James

Re: Sorting Issue

mphekin12 — Mon, 03 Dec 2012 14:06:54 GMT

I agree with you James.

Re: Sorting Issue

Wed, 24 Apr 2013 05:09:49 GMT

i have the same problem and setting sort state of listbox to ascending isn't working for me.

do you know if this issue exist in SR2?

is there another workaround for it?

Re: Sorting Issue

Wed, 24 Apr 2013 10:58:27 GMT

We've recently upgraged to 11.2 SR1.

I can't manage to replicate the problem, which could mean it has been fixed. However, if it turns out this is not the case I will post again to this thread.

James