Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
T_Mcgee
Contributor
Contributor

Different colors for column subtotals in pivot table

Hello! I currently have a Vizlib pivot table with multiple measures at the rows and two dimensions at the columns. Does anyone have a suggested script on how to make the background color of the dimension column totals different? I only found a way to color the totals but it's the same color for all. 

I have a table like screenshot #1:

screenshot1.PNG

but I need it to be like in screenshot #2:

screenshot2.PNG

Even something like this would be OK:

screenshot3.PNG

Thanks in advance! 

Labels (4)
3 Replies
lockematthewp
Creator II
Creator II

In either the dimension or the expression, click the + symbol next to it. then put in a value for Background color. You can use either = blue() or like =rgb(0,0,255)

T_Mcgee
Contributor
Contributor
Author

Can I just do it so that it only colors the total column for each dimension and not all the columns? 

piersbatchelor_vl
Partner - Contributor III
Partner - Contributor III

The totals section can be styled separately, feel free to get in touch with us at support@vizlib.com for more detail. We introduced more styling options for totals in the release below

https://community.vizlib.com/support/discussions/topics/35000011883