Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

Pivot table chart "show partial sums" total custom visual background

In a pivot table chart, when you tick show partial sums you get a summed column that has a grey background (for the light theme) is there a way to customise this:

fiilll.png

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Click on the + in front of the expression on the Expression tab, select background color and enter an expression in the Definition field like =if(SecondaryDimensionality()=1, lightblue()). Depending on the number of dimensions you may have to use another value then 1. Experiment to see what works for your pivot table.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

Click on the + in front of the expression on the Expression tab, select background color and enter an expression in the Definition field like =if(SecondaryDimensionality()=1, lightblue()). Depending on the number of dimensions you may have to use another value then 1. Experiment to see what works for your pivot table.


talk is cheap, supply exceeds demand
matthewp
Creator III
Creator III
Author

excellent!

What about the top row..

2fill.png

sunny_talwar