topic Re: How to put background color in a pivot table using expression ? in QlikView

How to put background color in a pivot table using expression ?

Anonymous — Fri, 13 Jul 2018 11:15:37 GMT

I want to highlight the cells in expression columns (Design, Vendor runoff & Launch) with yellow if the value of document is 'P', in a pivot table using visual cues.

Please assist.

Re: How to put background color in a pivot table using expression ?

sunny_talwar — Fri, 13 Jul 2018 11:20:09 GMT

So, if any of the three expression have P, you would want to highlight the complete row? or are you looking to just highlight the cell with P in it?

Re: How to put background color in a pivot table using expression ?

Anonymous — Fri, 13 Jul 2018 11:21:14 GMT

just that cell....

Re: How to put background color in a pivot table using expression ?

sunny_talwar — Fri, 13 Jul 2018 11:23:53 GMT

Try this for background color expressions

For Design expression

If([Design] = 'P', LightRed())

For Vendor runoff expression

If([Vendor runoff] = 'P', LightRed())

For Launch expression

If([Launch] = 'P', LightRed())

Re: How to put background color in a pivot table using expression ?

Anonymous — Fri, 13 Jul 2018 11:45:13 GMT

I have tried these expressions.

My question is where in pivot table I should put these expressions ?

Re: How to put background color in a pivot table using expression ?

sunny_talwar — Fri, 13 Jul 2018 11:47:31 GMT

It should be on the Expressions tab under Background Color or Text Color.. depending on what you want to color...

Re: How to put background color in a pivot table using expression ?

Anonymous — Fri, 13 Jul 2018 12:06:06 GMT

Thanks Sunny....