Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

set color for some of totals in pivot table

Hello everyone,

I have a problem with totals. I have to close totals for one expression column. I have set same background color and text with

this formula ( =if(rowno()=0, rgb(200,200,200)) ). It workwd well for the last dimentions total but the first and second columns totals are still visible.

Does anyone have an idea?

error loading image

Tags (3)
1 Solution

Accepted Solutions
brenner_martina
Valued Contributor II

AW:set color for some of totals in pivot table

Hi,

you can use Backgroundcolor and Textcolor in the expression by clicking the +-sign. Than use the expression:

If(Dimensionality()= 3,Grey())

Dimensionality() shows the number of the subtotal for that dimension

2 Replies
brenner_martina
Valued Contributor II

AW:set color for some of totals in pivot table

Hi,

you can use Backgroundcolor and Textcolor in the expression by clicking the +-sign. Than use the expression:

If(Dimensionality()= 3,Grey())

Dimensionality() shows the number of the subtotal for that dimension

Not applicable

AW:set color for some of totals in pivot table

Thank you Martina. I did not now this Dimensionality formula.

Community Browser