Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anybody know how to insert a marker icon in Qlikmaps that will change colours depending on selected values. (i.e an if statement that involves {$<Region='USA'>} etc.)
Hi Fran, this might not answer your set analysis question directly but it should get you down the road.
Also, I posted this because I could not find the answer elsewhere on this same/similar topic.
////////////// pull in a field from a table...MemID in my case.
mem:
load Distinct MemID Resident sca;
////////////// use that field to create a random color (or of course build your own static RGB's with an inline table
col:
Load MemID,
//Rand() as random,
rgb(
round(rand()*255),
round(rand()*255),
round(rand()*255)
) as MemColor
Resident mem;
//////////////////////////// Then in the Marker Icon box this is the formula using the field from above
='autocolor,' & MemColor
Thanks,
Brooks