Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kidbank3
Contributor III

color expression with above function not working

My color expression if(sum(length)<above(sum(length)),red()) does not work if my table has multiple dimensions.

How can I have this expression work with multiple dimensions?2016-05-25 16_18_43-Qlik Sense Desktop.jpg2016-05-25 16_18_54-Qlik Sense Desktop.jpg

1 Solution

Accepted Solutions
MVP
MVP

Re: color expression with above function not working

Can you try this:

If(Sum(length) < Above(TOTAL Sum(length)), Red())

4 Replies
alexdataiq
Contributor III

Re: color expression with above function not working

I believe that above() and below() doesn't work on Pivot Tables, only on Straight Tables or Charts that have an Straight Table equivalent.

MVP
MVP

Re: color expression with above function not working

Can you try this:

If(Sum(length) < Above(TOTAL Sum(length)), Red())

kidbank3
Contributor III

Re: color expression with above function not working

Wow, such a simple change.  Thanks Sunny!  This wouldn't have occurred to me. 

To Alejandro, I tried converting the pivot to a straight table but the color expression still wouldn't work if there were two dimensions.

alexdataiq
Contributor III

Re: color expression with above function not working

Well, I guess there's something new to learn, hehehe. Thank you Sunny and Michael!

Cheers