topic Re: How to add conditional formatting in a pivot table in App Development

How to add conditional formatting in a pivot table

Kirsten — Tue, 21 Dec 2021 20:02:52 GMT

Hi I would like to add conditional formatting in a pivottable. I would like to be every value under 70% to be red, between 70 and 85 to be orange and above 85 to be green.

I know I should use master items under measures though when I fill in the specifics under segment colors and then create, nothing happens to my table. The colors remain white. Also I would like to have different colors then displayed in the image -> how to adjust?

Re: How to add conditional formatting in a pivot table

Ksrinivasan — Sat, 06 Feb 2021 12:11:23 GMT

hi,

find the link

https://community.qlik.com/t5/New-to-QlikView/Change-color-in-a-pivot-table/m-p/263423

ksrinivasan

Re: How to add conditional formatting in a pivot table

Anil_Babu_Samineni — Sat, 06 Feb 2021 16:14:13 GMT

You can create conditions background and text color like in Pivot table

If([Your measure]<=Num(0.7, '#,0%'), Red(), If([Your measure]>Num(0.7, '#,0%') and [Your measure]<=Num(0.85, '#,0%'), Yellow(), Green()))

Re: How to add conditional formatting in a pivot table

Gabriel — Wed, 10 Feb 2021 12:03:17 GMT

Hi,

In Pivot table, under the expression, if you expand the expression further down there is the section for background and text colour expression. In there you can define the criteria you wanted to use for conditional colour changes.

Re: How to add conditional formatting in a pivot table

Kaushik2020 — Wed, 12 Mar 2025 10:02:52 GMT

You should be able to add under background expression for the Measures.

If([measure]<=Num(0.7, '#,0%'), Red(), If([measure]>Num(0.7, '#,0%') and [measure]<=Num(0.85, '#,0%'), Yellow(), Green()))

Also if you would like to have a specific shade of color, you can use hex code as well.