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: 
louise119
Creator III
Creator III

Background color of table

Hi,
Can I change the background color of table chart?
I wanna change the color of the column "total" with table chart.

Thank you.

1 Solution

Accepted Solutions
Tanish
Partner - Creator
Partner - Creator

Hi Louise,

You can use this Formula in Background Color Exp. in Pivot table

Pick(Dimensionality()+1, rgb(6,74,113),(Pick(Dimensionality(), rgb(240,255,255))))

Tanish_0-1691138316810.png

This will not just color your total line but will color your subtotal line as well.

Hope this will help....🙂

View solution in original post

4 Replies
Prithika
Contributor III
Contributor III

you can change the color of the table by

click the table => select appearance =>select styling => background color 

in background colors you can select the color you wish or u can use expression.

Tanish
Partner - Creator
Partner - Creator

Hi Louise,

You can use this Formula in Background Color Exp. in Pivot table

Pick(Dimensionality()+1, rgb(6,74,113),(Pick(Dimensionality(), rgb(240,255,255))))

Tanish_0-1691138316810.png

This will not just color your total line but will color your subtotal line as well.

Hope this will help....🙂

louise119
Creator III
Creator III
Author

Thank you. 
I'm gonna use pivot table instead of table chart.

louise119
Creator III
Creator III
Author

Thank you so much!