Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Not applicable
Author

Ah excellent, thank you.