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: 
Keitaru
Creator
Creator

How do I Not have Total Row Colored on pivot Table

 

Hi I'm trying to not have my Pivot table total row not be coloured but is not sure how to go about it.

Capture.PNG

 

What would I need to include to not have total Row colored?

if(wildmatch([TRO Aging],'a)*'),lightred(),
if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))

1 Solution

Accepted Solutions
mfarsln
Creator II
Creator II

Hi,

Try this;

if(Dimensionality()<>0 and SecondaryDimensionality()<>0,  
  if(wildmatch([TRO Aging],'a)*'),lightred(),
  if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))
)

View solution in original post

4 Replies
mfarsln
Creator II
Creator II

Hi,

Add dimensionality() function to define totals color.

if(Dimensionality()<>0,  
  if(wildmatch([TRO Aging],'a)*'),lightred(),
  if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))
)
Keitaru
Creator
Creator
Author

If there is a total on the Column as well is there a way of removing its color as well?

mfarsln
Creator II
Creator II

Hi,

Try this;

if(Dimensionality()<>0 and SecondaryDimensionality()<>0,  
  if(wildmatch([TRO Aging],'a)*'),lightred(),
  if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))
)
Keitaru
Creator
Creator
Author

That worked thanks.