Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Hi Channa!
Did not work.
CAN YOU SHARE YOUR EXPRESSION
Hi Channa,
SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL) / SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL_12M)