Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Fix background colors on pivot chart

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.

1 Solution

Accepted Solutions

Re: Fix background colors on pivot chart

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

...

2 Replies

Re: Fix background colors on pivot chart

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

...

Not applicable

Re: Fix background colors on pivot chart

Hi Sunny,

This works perfect, thank you so much.

Community Browser