#13 Add information by coloring with a second measure 🎨
Add information to your chart by coloring with a second measure 🎨
In a previous post, I started to talk about colors with gradient coloring https://lnkd.in/dTWHAbF
You can also use color to display a second information to the user. It's strongly efficient when you show quantity with the bar, and KPI like % margin or profit, avg age or income, or quality level ...
Adding a Legend as I did with a text box i mandatory to well explain what the user see
Today's recipe is composed by Colormix1(), Max(), Aggr() 🧙
This coloring can be achieved with built in option of Qlik Sense, but worth doing it by yourself no ?
❓How To❓
Coloring by expression with :
colormix1(
avg(MonthlyIncome) /
max(total Aggr(avg(MonthlyIncome),[Job Role]))
,rgb(241, 196, 15),rgb(231, 76, 60))
ColorMix1 return a color between the two last parameters based on the value between 0 and 1 of the first one
Finally remember to add a tooltip with the avg(MonthlyIncome) !
Read more :
