topic Colours in pivot table for one column in QlikView

Colours in pivot table for one column

Thu, 05 Apr 2012 13:00:04 GMT

Hi,

How to give one colour for entire colour(back ground) in pivot table.

regards,

Colours in pivot table for one column

Thu, 05 Apr 2012 13:37:05 GMT

You can use the function ColumnNo () to set the background color as desired

Ex.:

In your expression / background color

IF(ColumnNo() = 3, RGB(230,230,230), RGB(255,255,255))

Colours in pivot table for one column

Jason_Michaelides — Thu, 05 Apr 2012 13:38:30 GMT

Expand the expression in the properties dialogue box and click on background. Enter a Colour (e.g. LightRed()) in the definition window, or RGB(x,y,z) or any other expression that resolves to some kind of colour setting (see F1 help for the possible colour functions)

Hoep this helps,

Jason

Colours in pivot table for one column

jagan — Thu, 05 Apr 2012 13:55:00 GMT

Hi,

Expand the Background color expression and give the below expression

=RGB(255, 0, 0) for red

=RGB(0, 255, 0) for green

etc.

Hope this helps you,

Regards,

Jagan.