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: 
mikecrengland
Creator III
Creator III

Expression Attributes and column totals

Hello All -

I'm using Expression Attributes to conditionally color columns in a straight table. It's a simple greater than or less than 'If' statement (>20, green or <5, red). Is there a way to not color the expression total?


2017-08-10_8-10-48.png


I'm using v12.1 SR7.

Thanks!

mike

1 Solution

Accepted Solutions
mikecrengland
Creator III
Creator III
Author

This was so close! the <> 0 didn't work, so I tried > 0 and, bingo, no more color.

Thanks!

View solution in original post

5 Replies
vinieme12
Champion III
Champion III

The total row rowno() is 0 , so add another condition to check for the total row as below

if(Rowno()<>0,

          if ( expression>20,green(),

                         if(expression<5,red())

                    )

     )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sergio0592
Specialist III
Specialist III

It should works with

=if(Dimensionality()=1,if(sum([Group1 trips])>20,green(),if( sum([Group1 trips])<5,red())),Black())

mikecrengland
Creator III
Creator III
Author

Hello Jean-Baptiste,

Thank you for the suggestion, but it unfortunately removed the color completely.

mike

mikecrengland
Creator III
Creator III
Author

This was so close! the <> 0 didn't work, so I tried > 0 and, bingo, no more color.

Thanks!

sergio0592
Specialist III
Specialist III

I have tried with a sample and it works. Try to add a dimensionnality() expression for see what it returns.