9 Replies Latest reply: Sep 11, 2017 7:01 AM by Shraddha Gajare RSS

    sorting legend

    Chan HS

      Hi,

       

      I have a field called Priority which has the following values: High, Medium, Low, Waiting and blanks.

       

      To gather the results of only High, Medium and Low, i used the following:

       

      if("Priority"='Low', "Final Risk Rating", if( "Priority" = 'Medium', "Priority", if ("Priority" = 'High',"Priority"))) as "Priority"

       

      and stored the results in a qvd file. When I load the data out from the qvd file, i used the following code:

       

      if(lower("Priority")='low',dual('Low',3),if(lower("Priority")='Medium',dual('Medium',2),dual('High',1))).

       

      However, the legend comes out in the ordre of High, Low then Medium. How do I sort the legend properly into High, Medium, Low (or Low, Medium, High)?

      Capture.PNG

       

      Also, is it possible to change the colours of the legend to whatever i want? Currently, the colours as shown below are not what I want. I want the >90% to be blue, 80-90% be yellow and <80% be red. How should i do this?

      Capture.PNG

       

      Thanks!