Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Saryk
Partner - Creator II
Partner - Creator II

Order by a measure without showing it on graph

Imagine we sell 4 items, A, B, C and D ; and we have 10 employees E1 - E10.

I have a stacked bars graph that has as a dimension the employees, and as measures the number of sales of each item - so sum(SalesA), sum(SalesB), etc.

I would like to order the employees by descending order of total sales, but I don't want to show the total number of sales in a separate measure, since I already have it at the top of my stacked bars.

How can I do that ?

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

in the chart 

under the sorting tab : 

select the employee dimension 

change the sorting from auto 

then select sort by expression 

and inside put your expressions for total sales

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

in the chart 

under the sorting tab : 

select the employee dimension 

change the sorting from auto 

then select sort by expression 

and inside put your expressions for total sales

Saryk
Partner - Creator II
Partner - Creator II
Author

Thank you, that works !