Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I color a 'Totals' row in a pivot table? - QlikSense

- QlikSense

- Pivot Table
- Styling/Formatting

- Totals

Hi,

How do I add a background color to my 'total' rows in a pivot table? I would like the rows to be more distinct.

TIA.

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

If(rowno() =0, rgb(), white())

Or

If(dimensionality()  =0,rgb(),white())

Put one of these expression in background color box of measure.

I hope it is helpful.

View solution in original post

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

If(rowno() =0, rgb(), white())

Or

If(dimensionality()  =0,rgb(),white())

Put one of these expression in background color box of measure.

I hope it is helpful.

Not applicable
Author

Thank you for your answer for Shraddha.

Do you also know if we can color the Total title row as well?

TIA

shraddha_g
Partner - Master III
Partner - Master III

We cant color title row.

heij1421
Partner - Contributor III
Partner - Contributor III

If your total row is in the first column, then use

If(ColumnNo() =0, rgb(), white())

and you even can use nested ifs for more colors:

IF([Exec P&L Calculation]='c', RGB(210, 210, 210),
    IF(ColumnNo()=0, RGB(197,217,241)
       ))