2 Replies Latest reply: May 9, 2016 11:56 AM by Chris Waterworth RSS

    Sorting by secondary value?

    Chris Waterworth

      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