3 Replies Latest reply: Sep 2, 2016 10:06 AM by Shahbaz Khan Mohammed RSS

    Map colors by top 10 ranking

    Amey Diwanji

      Hi all,


      I am using custom colours ( colour by expression) in map objects. I want to show my top scoring locations  in red colour and other in green colour how can I do that? So basically I am using sum function, rank function and if function. But I am not getting the desired result? I am using qlik sense 3.0 with below expression


      If((Rank(sum(([Rank 1 ]*[Weightage1)+([Rank 2]*[Weight 2])),0,Location))<=10,rgb(150,0,0),rgb(0,125,125))


      Please help to correct this expression