Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

How to add conditional formatting in a pivot table

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.

Conditional formatting.PNG

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?



3 Replies

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner - Specialist III
Partner - Specialist III



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.