Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys!!
I have a table with a lot of lines. I would like to format the values following one rule.
For example:
The higher value will be red, intermediate yellow and lower green, making a gradient through the other valus of the line.
My expression to format
(SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA))
It's killing me lol.
Thank you guys!!
I tried using ColorMix Wizard in qlikview.
ColorMix1 ((1+Sign(2*((SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) -RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))/(RangeMax (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total)))-RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))-1)*Sqrt(Fabs((2*((SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) -RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))/(RangeMax (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total)))-RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))
/
before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))-1))))/2, RGB(255, 34, 0), RGB(0, 255, 17))
The expression is "OK" but isn't working.
Why?
Tks!