Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

Hi.

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

spividori
Specialist
Specialist

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
Specialist III
Specialist III

Hi Michael,

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

thanks,

Rajesh Vaswani