Background Color in a Pivottable

[Frédéricdh]

In my Pivottable I want to color the background but Qlik color the Total too:

the expression for the color is Pick(Match(Minstring({<Week=>} Location), 'A', 'B'), rgb(X,Y,Z), rgb(Y,X,Z))

and sometimes Qlikview doesn't color the location although it colored for another installation:

[kaushiknsolanki · Accepted solution]

Check this link for a guide.

https://community.qlik.com/t5/App-Development/How-do-I-Not-have-Total-Row-Colored-on-pivot-Table/m-p...

[Frédéricdh]

Hello,

thank you for the answer but something doesn't work. Some time the location is colored, some times not and the location is the same for the facility. I don't understand why