Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

3 Replies
whiteline
Honored Contributor II

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

Hi.

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

spividori
Valued Contributor

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

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.

rajeshvaswani77
Valued Contributor III

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

Hi Michael,

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

thanks,

Rajesh Vaswani

Community Browser