Change Pivot table column background color

[marco_puccetti]

Hello i need to know how to change the background color of specific column on a pivot table; can also been done dinamically?

Thanks

Marco

[gautik92]

try to change the background color of expression lik

if(Sum(Sales)<0,Red(),Green())

[qlikviewwizard]

Hi check this thread:

How to create conditional background color?

[marco_puccetti]

And how can be made statically on specific columns?

Marco

[gautik92]

have a look at this

[#6]

Hi,

it can be done int he visual Cues Tab

[#7]

Hi,

Add this in the background color area of the expression, it will only format the required row

=if(<Enter the row name required>)

    ,rgb(255,255,0)

    ,rgb(255,255,255)

)

[#8]

Hi,

Go through the below link it might help u,

Color of total rows in pivot table

[marco_puccetti]

And if i have only dimensions on the pivot table is it possible to set the background?

Marco

[gautik92]

how can you have oly dimesion in ur pivot table?