Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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))
Thanks for your immediate response.
In our case year is dynamical value. We can't strict to mention the value of the year.