Map chart area layer colouring using custom numerical banding

[mattphillip]

Hello!

I hope someone can help. We've created a map chart for our international applicants which is coloured by number of applicants. However, the issue we have is that 2/3 countries provide the vast majority of applicants (e.g. 500+), with the remaining countries providing relatively few in comparison (<150). As a result, the colour gradient is heavily skewed towards those 2/3 countries offering the most applicants with other countries basically being coloured the same. We'd like to specify by expression, numerical bandings to provide better contrast of colour gradients at the lower end of the scale. We've managed to do this  and have assigned different colours to each band. However, we'd like to know whether it's possible to achieve a similar result using a single colour?

Appreciated.

Matt

[theoat]

Can it be by using an exponential function of the number of candidates in order to widen the gaps between the high numbers of candidates?

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[mattphillip]

Hi Theo,

Thanks for the reply. Can you expand on how to do this? I don't quite follow.

Appreciated.

Matt

[Clement15]

Hello, you can use a Exponential or squared in your measurement to reduce the deviation from the lower values.

Fonctions exponentielles et logarithmiques | Aide QlikView

[theoat]

Where you enter the number of candidates, improve the feature like this :

exp([Number of candidates])

This will widen the gaps.
You can leave the formula [Number of candidates] as a label expression to keep a readable legend.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[mattphillip]

Hi Theo,

I've tried the following with two colours however I'm still getting very little gradient variation:

=ColorMix1(sqrt([Distinct Applicants])/sqrt([Total Distinct Applicants]),red(),white())

Any ideas?

[theoat]

Try with exp() instead of sqrt().

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE. 

[theoat]

With this type of function, do not use a division. Simple the number of distinct candidates.

[mattphillip]

Hi Theo,

Right no luck I'm afraid. The map is now all grey.

=ColorMix1(exp(count (distinct [Applicant ID])),red(),white())

Sorry if I'm causing your grief.

[theoat]

Don't use the expression of color but the color by measure.

Without the exp function I have this :

 

With the function, i have this


Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.