Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

antoniodneto
Contributor

Help with Colormix or another function

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!!

1 Reply
antoniodneto
Contributor

Re: Help with Colormix or another function

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!

Community Browser