Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
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))