New to QlikView

[Zwax]

oh ok - sorry I didn't specify it.

Just to understand this: 

This is only for the more advanced stuff, where you often use set analysis - right?

Easy stuff like: If(Test<='148',LightBlue(),) seems to works fine.

[sunny_talwar]

This should, but this will highlight all Tests under 148.... 

[BrettBleess]

Line, did Sunny's post help you get things working as you wanted?  If so, please be sure to use the accept as Solution button on the post(s) that helped, so he gets credit and others know what worked.  If you are still working upon things, here is a Design Blog post that may be of some use, actually a couple of them:

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

The only other thing that will likely help is if you can work up an app with dummy data etc. so folks can see exactly what you have going on, that should help a great deal.

Regards,
Brett

[Zwax]

Sadly not. I haven't had much time to look at it, but I haven't given up yet.

Sure.  Have added a quick sample. I would like to highlight only the highest number under the limit, and not all the values under:

[sunny_talwar]

Try this

If([Sum_Amount] = Max(TOTAL Aggr(Sum({<EVENT = {"=Sum(AMOUNT) < vLimit"}>}AMOUNT), EVENT)), Yellow())