topic Re: chart sort order changes by itself after reload in QlikView

chart sort order changes by itself after reload

Tue, 24 Feb 2015 14:29:43 GMT

Hi,

We have a straight table and in the properties of the table, we have sorted the table by certain fields in specific order. However, this is second time today that I have noticed that the order of the sort has changed by itself

Can someone please tell me what are the general reasons if the order of columns in sort has changed?

Shah

Re: chart sort order changes by itself after reload

MK_QSL — Tue, 24 Feb 2015 14:31:26 GMT

What is the Sort Order you kept?

If there is nothing selected in Table under sort tab...this could be possible...

Re: chart sort order changes by itself after reload

jonathandienst — Tue, 24 Feb 2015 14:32:02 GMT

Perhaps it is sorted by load order and the order has changed in the source data?

Re: chart sort order changes by itself after reload

Oleg_Troyansky — Tue, 24 Feb 2015 14:47:35 GMT

Sort order in Straight Tables can change if the order of columns, or the number of available columns changes. For example, if one of your dimensions become unavailable after reload, the sort order is likely to change.

A specific example would be helpful for more detailed troubleshooting.

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: chart sort order changes by itself after reload

Fri, 27 Feb 2015 07:35:26 GMT

Yes, its a straight table. The problem is that neither any expression nor a dimension has changed but every morning when I open the Qlikview report, the order of column in sort has changed. I have even disabled the interactive sort but somehow the order of column changes. There is not addition or removing of any expression or dimension in the straight table

Re: chart sort order changes by itself after reload

Anonymous — Fri, 27 Feb 2015 07:42:14 GMT

Hi Syed,

when sorting by load order , the order will be changed after reload if any changes are made in source data.

are your reloads scheduled daily and at what time?

Please check before reloading the data by comparing in Document and Database.

Regards

Neetha

Re: chart sort order changes by itself after reload

Fri, 27 Feb 2015 07:57:41 GMT

Hi All,

Thanks for the replies. Actually its the priority of columns that is changing and this is very strange. For example, If I sort it by column1, column2 , column3 etc and save it. The next morning, its column3, column5, column1 etc. The strange thing is that every morning, the priority changes and they change to the same priority of columns no matter how I change it during the day

Re: chart sort order changes by itself after reload

marcus_sommer — Fri, 27 Feb 2015 11:53:58 GMT

I have heard that there is a sort-bug in table-carts in SR9 and SR10 - maybe it's connected.

- Marcus

Re: chart sort order changes by itself after reload

Tue, 17 Mar 2015 14:58:03 GMT

Hi,

I have the same problem as Syed, sort order in tables changes after reload.

Furthermore, I also noted that sorted order in a report was different from the representation that I actually have in the application.

Looks very likely that there is some kind of bug, just as Marcus referred to.

/Anders

Re: chart sort order changes by itself after reload

Fri, 10 Apr 2015 11:19:41 GMT

Hi,

I have the same problem with a chart table in SR9 that I use in a qlikview report, after reload the document in the server the order of the column priority change,

Original:

After reload:

With the qlikview desktop I have not this problem, any workarround?

Javier

Re: chart sort order changes by itself after reload

Mon, 13 Apr 2015 09:55:21 GMT

I have tested the same document with 11.20 SR10 and I have the same problem, I think it is not resolved in the last release.

Re: chart sort order changes by itself after reload

Tue, 14 Apr 2015 07:20:45 GMT

Same problem here in 11.20 SR9

workaround: put a copy of the column that has to be sorted as first column and hide it...

The issue is that the reload is sorting on the first column (dimension or expression) instead of the sorting priority set on the sorting tab.

Re: chart sort order changes by itself after reload

Mon, 04 May 2015 16:25:17 GMT

Finally this problem it is a bug in SR9 and SR10 and resolved in 11.20 SR11 beta, I installed a patch to 11.20 SR9 that finally resolved the problem.

Re: chart sort order changes by itself after reload

amirkachlon — Tue, 06 Oct 2015 13:13:43 GMT

Hi,

I've got a workaround for you,

copy Rank expresion - without usage of colum(1), to the sort expresion of Compnia.

Regards,

Amir