Qlik Community

App Development

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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()))
)

View solution in original post

Keitaru
Creator
Creator
Author

That worked thanks.