Unable to lock sort priority order

Anonymous — Mon, 30 Jan 2017 13:41:10 GMT

Hi,

I'm attempting to keep my table sorted in a particular way, which is crucial to the presentation of the table. See attachment 1 for the sort order that I'm trying to achieve.

However, I also have a conditional expression, Major Group, which only appears when there is one brand selected. As soon as a user clicks on a brand, thus drilling down into the major group field, the sort priority changes! (see attachment 2 for the order that is now in place). Is there any way I can prevent the sort priority list from jumping around and destroying my table?

Thanks.

Re: Unable to lock sort priority order

vinieme12 — Mon, 30 Jan 2017 13:47:02 GMT

Create an inline table with the sort order for the dimension you want to sort.

Example

Load * inline [

Matches,MatchesSortorder

A,1

B,2

C,3

];

NOW SORT BY EXPRESSION AND use MatchesSortorder

topic Re: Unable to lock sort priority order in QlikView

Unable to lock sort priority order

Re: Unable to lock sort priority order