Format Pivot Chart

[bnelson111]

Has anyone experience in formatting the colour of the expression sum? See below you can see that the table is grey etc but the expression total colour has stayed white, I'm sure this is a setting somewhere but i have gone a little stare crazy.

Thanks Brett

[Kushal_Chawda]

Do you have Background expression for cell Color? or using Visual Cues?

[sunny_talwar]

May be try this approach to color:

Custom formatting table cells - The Qlik Fix! The Qlik Fix!

[bnelson111]

Background Expression

[jonathandienst]

Well I suggest then that you show us the expression...

[Kushal_Chawda]

what is expression?

[vikasmahajan · Accepted solution]

Click on expression -> select Background Color -> give set analysis -> if( col1 >col2,RGB( No,No,No))

Hope this helps you

Vikas

[pooja_sn]

Right click on a cell that you want to format -> Custom Format Cell -> set colors you want.

[Chanty4u]

if not custom format cell.

u can try with Dimensionality ()  also.

How to use - Dimensionality()