Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting by secondary value?

Dear Qlik

I have a table that shows the percentage conversion from one stage of production (Stage A) to another (Stage B), I have created a Bar chart showing the top five sites for conversion (top three are all 100%).

I would like a way to further rank the same data (in particular the top 3 projects) by a secondary measure "Site Value" (without it appearing as a separate bar on the graph).


I have considered  perhaps using a rank coupled with a match functions but am fairly green to Qlik and am having trouble.

Any help would be appreciated muchly.

Qind regards,

Chris

2 Replies
Gysbert_Wassenaar

Try sorting by an expression like [Measure1]+[Measure2]/1000000


talk is cheap, supply exceeds demand
Not applicable
Author

Ah excellent, thank you.