topic Color in Pivot cell in QlikView

Color in Pivot cell

Mon, 26 Oct 2009 20:11:04 GMT

I want to change color cell in a Pivot.

For value from 0 to 1.000.000 gradient white to green

For value > 1.000.000 green

I insert to following expression in color background normal calculate in Table properties (Visual properties)

ColorMix1 ( if ($(FatturatoAlGiornoCorrente) > 1000000, 1 , ($(FatturatoAlGiornoCorrente) / 1000000), white (), green ())

where variable FatturatoAlGiornoCorrente is the value in the column.

The result is always white color.

Thanks.

Antonio Benvenuti

Mon, 26 Oct 2009 21:17:39 GMT

Try using an If else to determine rgb(),

=If(value >= 1.000.000, rgb(0,255,0), rgb(0, 255 * (value/1.000.000), 0)

'value' could be a formula or if you use a variable in your loading script remember to use $([name of variatble])

Mon, 26 Oct 2009 22:48:26 GMT

I'm sorry I don't know what I was thinking.



=If(sum(Value) >= 1000000,
 rgb(0,255,0),
 rgb(255-ROUND(255 *(sum(Value)/1000000)),
 255 ,
 255-ROUND(255 *(sum(Value)/1000000))))

I added the ROUND function incase Qlikview doesn't convert a decimal to an integer.

This should move it from Bright Green to White

Problem though when inserting this code into the Pivot chart. It will not group the SUM(Value) by the dimension.

So I'm not sure if this will do it for you.