topic Re: Background colours in pivot tables in QlikView

Background colours in pivot tables

Tue, 07 Apr 2015 13:16:08 GMT

I have a pivot table where I want to highlight the "total" rows.

I was able to highlight the "Work Day" total by selecting the dimension AFTER Work Day in the Presentation tab, selecting sub-totals, and entering the expression "if(RowNo()=0,yellow())" as the background colour for that dimension.

However, when I try to set a background colour for the "Employee Total" by adding background colours to the "Work Day" dimension, I get all the dates in yellow, and when I try to set the background colour for "Name", nothing happens.

How can I set the background colour for the "Employee total" sub-total?

Re: Background colours in pivot tables

sunny_talwar — Tue, 07 Apr 2015 13:18:32 GMT

Use the concept for dimensionality() in your background color expression to achieve this. Something like this:

If(Dimensionality() = 0, Blue())

Please note: Actually dimensionality will depend on which level of subtotal are your trying to color.

Update: Attaching a sample

HTH

Best,

Sunny

Re: Background colours in pivot tables

PrashantSangle — Tue, 07 Apr 2015 13:21:56 GMT

Hi,

Right click on Total Cell-> custom Format Cell->select Background Color.

Regards