Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
2 Replies

Re: Sorting by secondary value?

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

Not applicable

Re: Sorting by secondary value?

Ah excellent, thank you.