In a Pivot Table, how to change the colour of the expression value when it exceeds certain value?

[#1]

hi

       can any one give me the answer .

[MK_QSL]

Considering that you have SUM(Sales) as an expression...

Go to Expression tab

Click on the + sign

Write

IF(SUM(Sales) > 100, Green())

as an expression in the background color..

Change Green() and 100 with your appropriate values...

[#3]

go to expression tab click on + icon go to text color,here you can put your condition for color

if(sum(value)>condition,rgb(100,120,120))

and also you can put this condition in background color if you want to change the background color of the table column.

Regards

Bhawna

[MarcoWedel]

Hi,

instead of defining a background or text colour expression under the expression in the expression tab, you can also define limits in the visual cues tab:

hope this helps

regards

Marco

[qlikmsg4u]

we can make it in visual cues in properties..hope Marco Wedel post will help