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: 
apalmtree
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
apalmtree
Creator II
Creator II
Author

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...

Thanks

Pierre

Custom Format Cell.jpg

h2895049
Contributor II
Contributor II

Hello,

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