topic Re: Conditional color for pivot table in QlikView

Conditional color for pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like some help with an expression to get conditional color for my pivot table. If one of the products appears twice in this case "Shoes" then i would like the colors "green and yellow ' to be highlighted in yellow.

Kind regards,

Esther

Re: Conditional color for pivot table

antoniotiman — Mon, 20 Nov 2017 08:21:56 GMT

May be

=If(Count(TOTAL <Products> Colours) > 1,Yellow())

in Conditional Color.

Regards,

Antonio

Re: Conditional color for pivot table

devarasu07 — Mon, 20 Nov 2017 08:23:37 GMT

Hi,

try like this.

=if(Aggr(count ({<Colours=>}Products),Products)>1,Yellow(),White())

Re: Conditional color for pivot table

Anonymous — Mon, 20 Nov 2017 13:20:07 GMT

Sorry I was not clear, my desired outcome is below.

Re: Conditional color for pivot table

sunny_talwar — Mon, 20 Nov 2017 13:22:38 GMT

A little modification to Antonio‌'s expression should work for you

=Aggr(If(Count(DISTINCT TOTAL <Products> Colours) > 1,Yellow()), Products, Colours)

Or this

Aggr(If(Count(DISTINCT Colours) > 1, Yellow()), Products)

Re: Conditional color for pivot table

sunny_talwar — Mon, 20 Nov 2017 13:22:39 GMT

A little modification to antoniotiman‌'s expression should work for you

=Aggr(If(Count(DISTINCT TOTAL <Products> Colours) > 1,Yellow()), Products, Colours)

Re: Conditional color for pivot table

Anonymous — Tue, 21 Nov 2017 02:49:15 GMT

Thank you, it works

Re: Conditional color for pivot table

Anonymous — Tue, 21 Nov 2017 02:49:36 GMT

Thanks