Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Designing a Table's Header

Hi All,

colors of the headers are effecting the total row as well,

is there a way to change it?

header.png

thanks!

19 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Nir,

still getting access denied

Andy

Anonymous
Not applicable
Author

please try again (forgive my lack of experience with these things)

awhitfield
Partner - Champion
Partner - Champion

Here you go, should of said that you need to select the actual cell you want to apply the customer colour to, I have also changed the null symbol to be '' blank on the presentation tab so you don't get the - displayed in the cell

HTH Andy

Anonymous
Not applicable
Author

1 NULL value, great!

2 cell color, i am looking on your qvw, but the color is still the same....

awhitfield
Partner - Champion
Partner - Champion

Sorry, I thought that was what you wanted! What colour should they be? The same as the other rows it the total columns?

Like this:

If so, see attached, again

Andy

Not applicable
Author

In QVW shared by andrew, you can change respective cell color using custom format cell.

Anonymous
Not applicable
Author

how are you doing this?

1 I am right clicking the grey cell (under the "Email" cell)

2 Select "Custom Format Adjust"

3 choose "Background Color", and then set it to a different color

that's what i get:

dsa.png

awhitfield
Partner - Champion
Partner - Champion

Yep that's all !

andy

Anonymous
Not applicable
Author

I still can't change the color,

I am using version 11 SR9, are you using it too by any chance?

ankitaag
Partner - Creator III
Partner - Creator III

Hi Nir,

You can write the background expression as =if(Dimensionality()=0,RGB(255,255,255),RGB(245,245,245))

where the dimensionality()=0 represents the Total value