Help with ColorMix2 in a Pivot Table

[antoniodneto]

Hi Guys,

I have this following pivot table

I built this table on QlikSense but I don't know how to use ColorMix2 on it.

I need to colour the values starting from green, yellow and highers in red.

My expression to calc is SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL)
/
SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL_12M)

Tks guys!

[Channa]

ColorMix2 (if(rangemin(5000000,rangemax(sum(CUSTOMS_VALUE_QAR),22))<2000000,-Sqrt(-(rangemin(5000000,rangemax(sum(CUSTOMS_VALUE_QAR),22))-2000000)/(2000000-22)),Sqrt((rangemin(5000000,rangemax(sum(CUSTOMS_VALUE_QAR),22))-2000000)/(5000000-2000000))), ARGB(255, 192, 192, 192), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 0))

try this

replace your expression 

measure:sum(CUSTOMS_VALUE_QAR)

Highest Limit:5000000

Medium:2000000

Lower:22

[antoniodneto]

Hi Channa!

Did not work.

[Channa]

CAN YOU SHARE YOUR EXPRESSION

[antoniodneto]

Hi Channa,

SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL) / SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL_12M)