topic Re: colormix, color gradient in QlikView

colormix, color gradient

arsenal1983 — Tue, 27 Sep 2016 09:41:15 GMT

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_1	CONTR_2	CONTR_3	CONTR_4
Q1	5,88	5,16	5,64	5,61
Q2	5,97	5,64	5,79	5,80
Q3	5,88	5,24	5,81	5,59
Q4	5,93	5,50	5,83	5,84
Q5	5,93	5,24	5,67	5,76
Q6	5,95	5,48	5,86	5,88
Q7	5,96	5,67	5,83	5,86
Q8	5,85	5,26	5,74	5,69
Q9	5,92	5,47	5,72	5,76
Q10	5,87	5,34	5,64	5,63
Q11	5,93	5,47	5,91	5,94

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

Re: colormix, color gradient

giakoum — Tue, 27 Sep 2016 09:47:06 GMT

Using ColorMix In Qlikview

Re: colormix, color gradient

Anonymous — Tue, 27 Sep 2016 09:57:14 GMT

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.