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: 
mgranillo
Specialist
Specialist

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
sunny_talwar

Can you try this:

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

View solution in original post

4 Replies
alexdataiq
Partner - Creator III
Partner - Creator III

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

sunny_talwar

Can you try this:

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

mgranillo
Specialist
Specialist
Author

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
Partner - Creator III
Partner - Creator III

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

Cheers