topic Color of total rows in pivot table in QlikView

Color of total rows in pivot table

Anonymous — Thu, 27 Oct 2011 14:38:10 GMT

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

Color of total rows in pivot table

its_anandrjs — Thu, 27 Oct 2011 14:42:57 GMT

Hi,

Yes use Background Color option and put there your choice color for background color

Right click -> properties -> click on plus sign -> select backcolor -> go to expression and set your color.

Let me know about this.

Rgds

Anand

Color of total rows in pivot table

Anonymous — Thu, 27 Oct 2011 14:57:27 GMT

No i only want to color the total row. the other rows are in another color.

Color of total rows in pivot table

its_anandrjs — Thu, 27 Oct 2011 15:20:30 GMT

Hi,

Yes it is possible do with instruction for total

Right click -> properties -> click on plus sign -> select backcolor -> go to expression and set your color.

If you have any sample so provide to me.

Rgds

Anand

Color of total rows in pivot table

Anonymous — Thu, 27 Oct 2011 15:35:48 GMT

No, not what i mean. Look at this picture. See the "Total" row. That's the one i want to put a color tp. Not the expression.

If it is possible of course =).

Color of total rows in pivot table

patrickanderson — Thu, 27 Oct 2011 15:46:32 GMT

Press Control+ G. (This will open Grid View)

Then Right click on the total Cell. You will now see Custom Cell Format or somethign like that, you can set colors for just the totals there. YOu may need to repeat a few times for each dimension.

Color of total rows in pivot table

matt_crowther — Thu, 27 Oct 2011 15:46:47 GMT

Make sure you have the 'Always Show Design Menu Items' checkbox checked under Settings > User Preferences > Design. Now Right-click on the Total row and select the new menu item 'Custom Format Cell' - alter the colours as you need.

Hope that helps,

Matt - Visual Analytics Ltd

Color of total rows in pivot table

Thu, 27 Oct 2011 16:08:25 GMT

Add this in the background colour area of the expressin, it will only format the total row

=if(rowno()=0 or isNull(rowno())

,rgb(255,255,0)

,rgb(255,255,255)

)

you change the colours using different RGB numbers

Color of total rows in pivot table

Anonymous — Fri, 28 Oct 2011 08:11:24 GMT

this one is promising. But my result shows rows that has no values,'-', too. And the show only because of the background change. I've tried to add som that the expression have to be >0 but the row still shows. Any ideas?

Color of total rows in pivot table

Fri, 28 Oct 2011 08:29:56 GMT

Not sure what you mean the expression only identifies what should be adifferent colour as you can see from the right column below totals have arowno() of 0. If you have null values that you don’t want to display in thepivot on the properties under "Settings for selected dimension"choose suppress when value is null.

your expression should still be the same sum(Revenue) for example and you put the formatting expression in the background area as described in the first reply (Right click -> properties -> click on plus sign -> select backcolor -> go to expression and set your color.)

Color of total rows in pivot table

Anonymous — Fri, 28 Oct 2011 08:34:52 GMT

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.

Color of total rows in pivot table

Thu, 07 Jun 2012 23:45:50 GMT

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

Re: Color of total rows in pivot table

Wed, 24 Oct 2012 08:27:19 GMT

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

Re: Color of total rows in pivot table

Anonymous — Wed, 24 Jun 2015 05:11:51 GMT

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

Re: Color of total rows in pivot table

qlikviewforum — Thu, 18 Jul 2019 14:44:46 GMT

Any solution for the below

https://community.qlik.com/t5/New-to-QlikView/How-to-change-the-Background-color-of-Partial-Total-in-Pivot/td-p/1603729