How to add conditional formatting in a pivot table

[Kirsten]

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?

[Ksrinivasan]

hi,

find the link

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

ksrinivasan

[Anil_Babu_Samineni]

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()))

[Gabriel]

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.