Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

View solution in original post

14 Replies
Highlighted

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

Highlighted
Creator II
Creator II

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

Highlighted

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

Highlighted
Creator II
Creator II

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 =). pivot.png

Highlighted
Partner
Partner

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.

Highlighted
Luminary
Luminary

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

Highlighted
Not applicable

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

View solution in original post

Highlighted
Creator II
Creator II

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?

Highlighted
Not applicable

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.

untitled.bmp

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