Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.