Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

The back color of total value in table

Hi, 
How can I change the back color of total value in table?

Thank you.

1 Solution

Accepted Solutions
RafaelBarrios
Partner - Specialist
Partner - Specialist

There is a trick you can try for Pivot table that wont work on normal tables

RafaelBarrios_0-1687890566749.png

 

in the measure look for "background color expression" option and try

if(IsNull( dimesion_name ),red())

 

 

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

View solution in original post

5 Replies
RafaelBarrios
Partner - Specialist
Partner - Specialist

Hi @louise119 

i affraid you cant.

options can be a bit different between Cloud and onpremise, but basicaly you can:

- On each dimension and expression you can change column background color, but will only affect values and not total.

- on Chart presentation option you will be able to change Header font color, content font color and mouse over background and font color.

 

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

RafaelBarrios
Partner - Specialist
Partner - Specialist

There is a trick you can try for Pivot table that wont work on normal tables

RafaelBarrios_0-1687890566749.png

 

in the measure look for "background color expression" option and try

if(IsNull( dimesion_name ),red())

 

 

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

louise119
Creator III
Creator III
Author

Thank you so much!

louise119
Creator III
Creator III
Author

Can I change the background color next to "total"?
it didn't change the color from white to dark gray.

test.png

 

RafaelBarrios
Partner - Specialist
Partner - Specialist

hi @louise119 

i've been testing but i don't have another trick for that.

Hope someone else add some trick for you.

best,