Change the background color in a pivot table depending on the level beneath

[#1]

Hello!

Right now I am playing arond with the Pivot Table in QlikView and I have the following problem:

In the Pivot Table i got three levels:

1. topicName
2. itemName
3. emotion

The color for 'emotion' depends on the label. For the label 'pos' it will be green, for 'neg' it will be red and for 'neu' it will be yellow.

I want the background color for itemName to be in the same color as the one with the maximum count.

For example: If itemName="Bacon" with the following counts: pos=6, neg=5, neu=3, the background color for Bacon should be green.

Please, also have a look at the attached QV-file.

Thanks!

Br Anders

[martin59]

Hi,

Look at the attached document. You'll find the expression.

Is that you want ?

[#3]

Hi

Could you please explain the expression, what you wrote in backgroundcolor..