Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try sorting by an expression like [Measure1]+[Measure2]/1000000
Ah excellent, thank you.