topic Background Color in a Pivottable in App Development

Background Color in a Pivottable

Frédéricdh — Thu, 22 Feb 2024 17:53:30 GMT

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:

Re: Background Color in a Pivottable

kaushiknsolanki — Thu, 22 Feb 2024 19:27:57 GMT

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/1683099

Re: Background Color in a Pivottable

Frédéricdh — Mon, 26 Feb 2024 13:58:02 GMT

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