Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Zwax
New Contributor III

Re: Mark only highest value under a limit - background color expression

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.

 

Re: Mark only highest value under a limit - background color expression

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

Support
Support

Re: Mark only highest value under a limit - background color expression

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
Zwax
New Contributor III

Re: Mark only highest value under a limit - background color expression

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:

191031_qv.png

Re: Mark only highest value under a limit - background color expression

Try this

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