topic Re: Different colors for column subtotals in pivot table in QlikView

Different colors for column subtotals in pivot table

T_Mcgee — Sat, 16 Nov 2024 20:15:32 GMT

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:

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

Even something like this would be OK:

Thanks in advance!

Re: Different colors for column subtotals in pivot table

lockematthewp — Thu, 15 Aug 2019 16:12:53 GMT

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)

Re: Different colors for column subtotals in pivot table

T_Mcgee — Thu, 15 Aug 2019 16:39:45 GMT

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

Re: Different colors for column subtotals in pivot table

piersbatchelor_vl — Thu, 29 Aug 2019 16:03:04 GMT

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