Fix background colors on pivot chart

[#1]

Dear Qlik Experts,

Attached is an app that I am testing. The pivot table has been color coded in the background.

However, when I click on the year selection, the color runs off, is there any way to make the color remains as it is?

The excel file is where the Qlik program is drawing the data from.

[sunny_talwar · Accepted solution]

Try this for your color

=pick(num(Only({1}[impact pre]&[likelihood pre])),rgb(0,0,0), //ie 01

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),

rgb(0,0,0),//10

...

[#3]

Hi Sunny,

This works perfect, thank you so much.