Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
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)



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.