topic Re: Color of BOXPLOT by Expression in App Development

Color of BOXPLOT by Expression

joshuahirsch — Sat, 16 Nov 2024 06:16:58 GMT

Hey Guys,

I just saw it's possible to change the color of Boxplots in QlikSense! I think it's new, cause I swear I searched it once and couldn't find it.

Anyway.
Now I want my Boxplot to have a nice color by expression.

I already tried it, but i can't manage to do it somehow...

So I have minutes as x and depth as y axis.

And as you can see, I want the color between 5 and 6 to be green, everything else red.

My expression: If(depth.avg > 5 AND depth.avg < 6, Green(), RGB(255,0,0)).

But as you can see, it's not working.

I would really appreciate some help! 🙂

Re: Color of BOXPLOT by Expression

Patrik_Lundblad — Fri, 22 Mar 2019 12:50:19 GMT

Hi Joshua,

The color expression in box plot was added in November 2017 release.

What it does is to color the entire box with a color based on your expression. So if I understand your case it won't color the area between 5 and 6 of the box. If that is what you want?

On the other hand if you want to color the box based on the entire box being inside the area from 5 to 6 then you would have to modify your expression to see if max(depth.avg) is less than 6 and min(depth) more than 5 then it should work.

Patrik.

Re: Color of BOXPLOT by Expression

joshuahirsch — Mon, 25 Mar 2019 08:18:36 GMT

Hi Plu,

thank you.

Is it somehow possible, to get the Quartile-Values instead of min max?

Re: Color of BOXPLOT by Expression

Patrik_Lundblad — Mon, 25 Mar 2019 09:26:25 GMT

Hi Joshua,

Sure, just replace the max/min aggregation with the aggregation for the quartiles. To see how we calculate the quartiles you can go into "box plot elements" in the property panel and turn off presets and then expand the "box start" and "box end".

Here is a new version of the app with a new color expression based on using Tukey for quartile calculations.

Patrik.

Re: Color of BOXPLOT by Expression

joshuahirsch — Mon, 25 Mar 2019 09:40:01 GMT

Awesome! Thank you so much.