Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Not applicable

Thank you for your answer for Shraddha.

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

TIA

Highlighted
Partner
Partner

We cant color title row.

Highlighted
Partner
Partner

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