topic Re: Change Pivot table column background color in QlikView

Change Pivot table column background color

marco_puccetti — Fri, 18 Sep 2015 09:00:50 GMT

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

Re: Change Pivot table column background color

gautik92 — Fri, 18 Sep 2015 09:06:33 GMT

try to change the background color of expression lik

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

Re: Change Pivot table column background color

qlikviewwizard — Fri, 18 Sep 2015 09:09:32 GMT

Hi check this thread:

How to create conditional background color?

Re: Change Pivot table column background color

marco_puccetti — Fri, 18 Sep 2015 09:27:21 GMT

And how can be made statically on specific columns?

Marco

Re: Change Pivot table column background color

gautik92 — Fri, 18 Sep 2015 09:29:15 GMT

have a look at this

Re: Change Pivot table column background color

Fri, 18 Sep 2015 10:07:24 GMT

Hi,

it can be done int he visual Cues Tab

Re: Change Pivot table column background color

Fri, 18 Sep 2015 10:17:48 GMT

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)

)

Re: Change Pivot table column background color

Fri, 18 Sep 2015 10:18:37 GMT

Hi,

Go through the below link it might help u,

Color of total rows in pivot table

Re: Change Pivot table column background color

marco_puccetti — Fri, 18 Sep 2015 10:24:27 GMT

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

Marco

Re: Change Pivot table column background color

gautik92 — Fri, 18 Sep 2015 10:25:33 GMT

how can you have oly dimesion in ur pivot table?

Re: Change Pivot table column background color

marco_puccetti — Fri, 18 Sep 2015 10:37:47 GMT

There are also expressions, but i can't find the manner to set the background color of fixed column.

Can you post me a screen shot of the dialog?

Thanks

Marco

Re: Change Pivot table column background color

gautik92 — Fri, 18 Sep 2015 10:41:49 GMT

PFA

Re: Change Pivot table column background color

qlikviewwizard — Fri, 18 Sep 2015 12:02:37 GMT

HI Did you able to manage to do ?‌