Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Color of total rows in pivot table

Is there a way to change backgroundcolor or text color to the total row in a pivot table?

14 Replies
Creator II
Creator II

i've tried the "supress value when null" but it didn't work. It doesn't like the backgroundcolor expression. I'll keep look in to it... see what causes it.

Not applicable

actually this worked for me. you just need to make sure you supress on all the field names on the left side of the pivot

Not applicable

Hi Matt,

Thanks for your post

Does anyone know how to setup a different color depending to the total row,

Example in the screenshot below, I would like to color the line Max in Grey, but color the line Total Max in Blue.

I can't see any option like Current Dimension and Expression...



Custom Format Cell.jpg

Contributor II
Contributor II


Your solutions is good and i was looking for something like that only.

But can we make only the Main total in color.the only the Last row of Total not the Sub Total.

Is there any way to only color the Mi