Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tyagishaila
Specialist
Specialist

Header of straight/pivot table

Hi,

Is there any possibility in QV to change only header's background/text color in Straight/pivot table?

Don't want to change whole expression's background/text color.

I have attached an image as per my need.

Thanks,

1 Solution

Accepted Solutions
greeshma_k
Creator III
Creator III

Go to User Preferences Design tab and check the option for 'Always Show Design Menu Items'

Then right click on the header cell of the pivot/straight table and choose Custom Format Cell option. You can change the background color here.

View solution in original post

10 Replies
greeshma_k
Creator III
Creator III

Go to User Preferences Design tab and check the option for 'Always Show Design Menu Items'

Then right click on the header cell of the pivot/straight table and choose Custom Format Cell option. You can change the background color here.

View solution in original post

awhitfield
Partner
Partner

Be aware that this will change the colour of all the header rows

tyagishaila
Specialist
Specialist
Author

Thanks Greeshma for quick reply.

Its working, but can I apply different colors on different cells.

Under Customer Format Cells --> Apply Change to -->

there is always only option available All Dimensions

your Suggestion is really appreciable,

Thanks again

tyagishaila
Specialist
Specialist
Author

Yes I checked,

Is there any possibility to apply different colors in different cells.

Plz suggest.

Thanks

greeshma_k
Creator III
Creator III

Hi Shaila,

I don't think that is possible.

tyagishaila
Specialist
Specialist
Author

Okay,

Thanks Greeshma

awhitfield
Partner
Partner

Hi Shaila,

you could always create a semi transparent text box with the required colour and position this over the top of your header cell, see the attached example.

Andy

tyagishaila
Specialist
Specialist
Author

Hi Andrew,

Actually it will not work with my pivot table, because it is customized table.

any ways,

Thanks, you spend your precious time to solve my problem

buzzy996
Master II
Master II

may be tis helps,

Two things u could be do for this,

1. Settings menu--User preferences--Design tan--click the check box "Always show the design Menu Items"

2.Right click on column(for whichever column u need format)--select "Custom format cell".