Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Honored Contributor III

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

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.

3 Replies
shraddha_g
Honored Contributor III

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

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

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

Thank you for your answer for Shraddha.

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

TIA

shraddha_g
Honored Contributor III

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

We cant color title row.