topic Re: Sort order changes on Access Point in QlikView

Sort order changes on Access Point

BlondeThursday — Sat, 16 Nov 2024 05:07:46 GMT

We have an application with a straight table that has a very specific sort order by an expression. Every time it refreshes through the Management Console the sort order I set vanishes and the application becomes pretty useless.

Has anyone found a way around this?

Re: Sort order changes on Access Point

olivetwist — Tue, 27 Nov 2018 15:38:49 GMT

Is the data used in the table object all in the same table? Have you tried creating the table in script and incorporating the expression as a sort field?

Re: Sort order changes on Access Point

marcus_sommer — Tue, 27 Nov 2018 15:39:54 GMT

Maybe the refresh really changes the results of the sort-expression or the sort-expression becomes invalid in any way. To check this you could try to display the sort-expressions within the chart.

Further check if there is a mix-match of different Qlik releases between the desktop client and the server - which often work but isn't recommended because there could occur strange errors.

Another possibility is that the object is corrupt in some way. Youc ould check this if you re-build it (copying the expressions-strings but not any of the properties - by cloning them you would also clone a possible error).

- Marcus

Re: Sort order changes on Access Point

BlondeThursday — Tue, 27 Nov 2018 15:47:47 GMT

No. The table is quite complex and is used to determine errors with the data and presenting the incorrect ones at the top...hence the sort order is critical.

Re: Sort order changes on Access Point

BlondeThursday — Tue, 27 Nov 2018 15:51:54 GMT

The server version differing from the desktop version is a possibility. Unfortunately the server is not under our control. And as it doesn't happen when I refresh it on the desktop client it seems a likely candidate. I'll see what I can find.

Re: Sort order changes on Access Point

BlondeThursday — Thu, 29 Nov 2018 14:31:43 GMT

Okay. We have QlikView for Windows 12.0.200000.0 on our desktops and the server version is 12.10.20600.0, but that's QlikView Server so will that ever be a match?

Re: Sort order changes on Access Point

marcus_sommer — Thu, 29 Nov 2018 16:25:18 GMT

The release mix-match might be the cause especially because the desktop release is quite old and quite near to the initial release. But like above mentioned I would at first check if there is anything wrong within the datamodel and if it is it might be fixable.

- Marcus

Re: Sort order changes on Access Point

nakuldev — Thu, 12 Dec 2019 10:16:46 GMT

Hi,

Even I have faced the same issue but it got resolved after promoting the dimension to the top in sort tab and sorting is provided to Dimension.

Regards

Nakul