Hello,
It's been six years so the original thread is most likely dead (Solved: Change Color of the Area layer - Qlik Community - 1330679). I tried the stated solution adapting the expression to produce my own (see below) counting distinct applicants within each UK postcode district. However, I cannot seem to get it to colour neither the area layer of my map or a table. Would someone be willing to cast an eye over this please?
=ColorMix1((aggr(count(distinct DistinctApplicant),[Partial Postcode])
-min(total(aggr(count(distinct DistinctApplicant),[Partial Postcode]))))
/(max(total(aggr(count(distinct DistinctApplicant),[Partial Postcode])))
-min(total(aggr(count(distinct DistinctApplicant),[Partial Postcode])))),'#FF4F5C','#00CE9E')
Appreciated.
Matt
