Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Pivot column background_colour

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.

2 Replies
Highlighted
Contributor III

Re: Pivot column background_colour

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

Highlighted
Not applicable

Re: Pivot column background_colour

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.