Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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.
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.
excellent!
What about the top row..
You might also be able to play around with this using Custom Format Cell
Custom formatting table cells - The Qlik Fix! The Qlik Fix!
https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Custom_Format_Cell_dialog.htm