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: 
qlikviewforum
Creator II
Creator II

How to change the Background color of Partial Total in Pivot table

I am unable to change the background color of final Total value which is in Pivot table. I tried using the custom format cell as well but I am unable to achieve it. Any idea how can I achieve this?

Total BG.jpg

 

 

 

1 Solution

Accepted Solutions
qlikviewforum
Creator II
Creator II
Author

I have achieved this using the below..

=If(Dimensionality() = 0, RGB(192,192,192))

View solution in original post

1 Reply
qlikviewforum
Creator II
Creator II
Author

I have achieved this using the below..

=If(Dimensionality() = 0, RGB(192,192,192))