Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
May be like this ?
=if(Aggr(Rank(Sum(score)), location)<=10,
rgb(150,0,0),
rgb(0,125,125))
Hello,
Sum(Aggr(If(Rank(Sum(Sales), 1),Red(),Green()) Location)) it helps you
=if(
(sum(Sales)&Location))<10,rgb(150,0,0),
if(
(sum(Sales)&Location))>10,rgb(0,125,125)
))