Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to color maps by expression.
e.x.:
I have Italy maps and I want to color the region by num max of type car in that region;
(if num max of type car is BMW, color red!
Thanks!
Ah sorry. you should also add region field to the aggr function.
Pick(Match(FirstSortedValue(BRAND,-aggr(sum(QTY),BRAND,REGION)),'BMW','AUDI','MERCEDES'),Red(),Green(),Blue())
Hi Stefania,
It should be sth like that.
Pick(Match(FirstSortedValue(BRAND,-aggr(sum(QUANTITY),BRAND)),'BMW','AUDI','MERCEDES'),Red(),Green(),Blue())
BMW will be red, AUDI will be Green and MERCEDES will be Blue with this expression.
Hi,
it doesn't work.
Can you share the app qvf file? If you can, I will look into the problem.
Ah sorry. you should also add region field to the aggr function.
Pick(Match(FirstSortedValue(BRAND,-aggr(sum(QTY),BRAND,REGION)),'BMW','AUDI','MERCEDES'),Red(),Green(),Blue())
yes
IT'S OK!
Thanks!