Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
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
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()))
)
Highlighted
Contributor III
Contributor III

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

Highlighted
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

Highlighted
Contributor III
Contributor III

That worked thanks.