topic Re: Color of total rows in pivot table - Null Row and Column in QlikView

Color of total rows in pivot table - Null Row and Column

Thu, 29 Aug 2013 07:01:10 GMT

Hey everyone,

in a pivot table i want to change the background color for the total rows (for example total for every period). I did it like this in the background expression for the formula:

=if(rowno()=0 or isNull(rowno()),
     white(),
     ...
)

But when I do it like this, the table adds a new column at the end which is totally empty and a new row at the bottom which is also totally empty. I think this is because of the rowno()=0.

Do you know a better way to do so?

Regards

Re: Color of total rows in pivot table - Null Row and Column

whiteline — Thu, 29 Aug 2013 08:22:39 GMT

Hi.

Use Dimentionality()=0 or SecondaryDimentionality()=0 instead (depending on the field orientation).

Re: Color of total rows in pivot table - Null Row and Column

spividori — Tue, 03 Sep 2013 13:32:15 GMT

Hi Michael.

In the Toolbar menu.select "grid design" then you right click on the total row and select "Custom cell format" and you choose the color you want.

Regards.

Re: Color of total rows in pivot table - Null Row and Column

rajeshvaswani77 — Tue, 03 Sep 2013 13:40:49 GMT

Hi Michael,

See if Visual Cues helps. More neater way of doing it.

thanks,

Rajesh Vaswani