Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tonneofash
Creator
Creator

Unable to lock sort priority order

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.

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.