topic Re: Pivot column background_colour in QlikView

Pivot column background_colour

Mon, 16 Dec 2013 12:09:54 GMT

I am using Pivot table with 3 dimension and 3 measures in which 1 Dimension is pivoted. Need to show the multiple background color for pivoted dimension.

In the above attachment Year is highlighted with multicolor for example.

Re: Pivot column background_colour

daveamz — Mon, 16 Dec 2013 12:25:09 GMT

Hi,

Use in "Background Color" the following expression:

pick(match(Year,2008,2009,2010), rgb(255,255,0), rgb(255,167,122), rgb(175,165,255))

Regards,

David

Re: Pivot column background_colour

Mon, 16 Dec 2013 12:33:56 GMT

Dear David,

Thanks for your immediate response.

In our case year is dynamical value. We can't strict to mention the value of the year.