Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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