Custom colour gradient on area layer map (QlikSense) using a scaling sum

[mattphillip]

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