Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

coloring for header in Pivot table

Hi All,

I have used Pivot table and to 1 dimension set the background color as per the data in it.

But when I drag the same dimension to the top of the expression to make it as a header, the coloring disappears.

Please can any one tell me how can this be done?

10 Replies
SunilChauhan
Champion
Champion

in propertes-> go to visualcube-> select you field -> underbackground  last color option and choose your color

hope this helps

Sunil Chauhan
Not applicable
Author

Hi Sunil,

I forgot to mention that the colors are not viewable when viewing the report through access Point.

When the report is opened through QV, it shows the colors

SunilChauhan
Champion
Champion

use IE plugin

Sunil Chauhan
Not applicable
Author

Still did not work.

SunilChauhan
Champion
Champion

can share screen shot for colored and non colored ?

Sunil Chauhan
Not applicable
Author

see the attached files

Through AccessPoint.PNG

Through QV Desktop.PNG

SunilChauhan
Champion
Champion

go to dimenion where items are roofing,Supa roof zincal etc

click on + sign before and go to background color

there you can code your color

for ex: Red(),Blue()

hope this helps

Sunil Chauhan
SunilChauhan
Champion
Champion

see the attached file for eexample

and snapshot also

hope this helps

Sunil Chauhan
Not applicable
Author

Hello Sunil,

I have done this only. But it is not reflecting in Accespoint.