topic Coloring Pivot table in QlikView

Coloring Pivot table

Wed, 03 Sep 2014 12:41:17 GMT

Hi Guru's,

In a pivot table is it possible to color the same as in the attached below. the upper side view is a dimention and left hand side is expression.

is it possible.

Re: Coloring Pivot table

udit_kumar_sana — Wed, 03 Sep 2014 12:47:57 GMT

try to do by using custom format cell

Re: Coloring Pivot table

crusader_ — Wed, 03 Sep 2014 12:49:19 GMT

Hi,

Use Custom Format Cell to change bkground color.

PFA result.

update:

Of course you should activate it in User Preferences Dialog.

Hope this helps.

Andrei

Re: Coloring Pivot table

sundarakumar — Wed, 03 Sep 2014 12:54:28 GMT

U should first change the chart type to straight table to format the cornor cell(Header of dimension). then change the type back to straight table. u wil have the same format as it was in straight table. just a trick

-Sundar

Re: Coloring Pivot table

mdmukramali — Wed, 03 Sep 2014 12:55:30 GMT

Dear,

Kindly find the attachment .

I hope it will help u.

Thanks,

Mukram