Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER 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.