Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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 II
Champion II

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())

                    )

     )

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

Hello Jean-Baptiste,

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

mike

mikecrengland
Creator III
Creator III

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

Thanks!

View solution in original post

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.