topic Re: Expression Attributes and column totals in QlikView

Expression Attributes and column totals

mikecrengland — Thu, 10 Aug 2017 14:15:00 GMT

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?

I'm using v12.1 SR7.

Thanks!

mike

Re: Expression Attributes and column totals

vinieme12 — Thu, 10 Aug 2017 14:42:51 GMT

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

)

Re: Expression Attributes and column totals

sergio0592 — Thu, 10 Aug 2017 14:51:56 GMT

It should works with

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

Re: Expression Attributes and column totals

mikecrengland — Thu, 10 Aug 2017 15:17:29 GMT

Hello Jean-Baptiste,

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

mike

Re: Expression Attributes and column totals

mikecrengland — Thu, 10 Aug 2017 15:18:17 GMT

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

Thanks!

Re: Expression Attributes and column totals

sergio0592 — Thu, 10 Aug 2017 15:31:14 GMT

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