Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

arsenal83
Contributor

colormix, color gradient

Hello all,

I have pivot table with two dimmenssios (Quesion and Controller).

The result is the average score the controller get for every question, scores: 1-6 (generaly the scores are close to the 6).

My expression: avg(SCORE)

  

CONTR_1CONTR_2CONTR_3CONTR_4
Q15,885,165,645,61
Q25,975,645,795,80
Q35,885,245,815,59
Q45,935,505,835,84
Q55,935,245,675,76
Q65,955,485,865,88
Q75,965,675,835,86
Q85,855,265,745,69
Q95,925,475,725,76
Q105,875,345,645,63
Q115,935,475,915,94

I would like like to collor the background of cells depends on the value. I expect  results simmilar as below:

Przechwytywanie.PNG

Tags (2)
1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: colormix, color gradient

2 Replies
giakoum
Honored Contributor II

Re: colormix, color gradient

filip_duchateau
Contributor II

Re: colormix, color gradient

Hi,

You can do this by using visual cues or by adding a background color to your expression.

For example, use If(avg(SCORE) >= 5,70,RGB(0,255,0),If(avg(SCORE) >= 5,50,RGB(255,0,0))) would turn all fields with an average score >= 5,70 into green and those with an average score < 5,70 and >= 5,050 into red.

Community Browser