topic Re: Color/size by Expression in Charts in QlikView

Color/size by Expression in Charts

Thu, 13 Aug 2009 17:50:15 GMT

Hi All,

Is it possible to control the color/size of symbols on a scatter-plot chart?

I want to have two more dimensions on the charts, similar to the charts on www.gapminder.com

Please advise if you have any idea, I'm quite a newbie on QV.

Thanks,
Tal

Color/size by Expression in Charts

Thu, 13 Aug 2009 18:22:38 GMT

Ok, I managed to control the bubbles size with the use of "Bubble Size Expression" on Expressions tab.

The color problem still remains...

Thanks,
Tal

Color/size by Expression in Charts

Thu, 13 Aug 2009 19:39:46 GMT

I managed to set colors by expressions for each of the twelve first color.

however, my expression is calculated will per item in a table, but as a scatter-plot it returns the same color (the toal - rgb(255,0,0).

I hope this image can express my problem:

http://taladmon.googlepages.com/ScreenShot001.png

Color/size by Expression in Charts

Wed, 02 Sep 2009 13:21:52 GMT

what is your dimension and expession setting? I have created a simple example with 3 fields, x,y,cat Set cat (1..x) as your chart dimension, x and y as expression.

When switching through the different scatter styles you can see changing colors and even changing symbols when selecting the first style.

Jürg

Color/size by Expression in Charts

Wed, 07 Jul 2010 19:50:27 GMT

I'm not sure if you still need an answer, but I came across a way to change the bubble color. Under the expressions tab, expand the options for the expression and choose background color. Then set your formula for determining your colors.

Here is an example from comparison of two values.

= If( A > B, argb(200,0,180,0), If( A < B, argb(200,180,0,0), argb(200,120,120,120) ))

If A is greater the bubble is green. If A is less the bubble is red. If A is equal the bubble is grey. I used ARGB() for the transparency option.

Re: Color/size by Expression in Charts

Sat, 31 Dec 2016 21:47:55 GMT

Men, six years later, and you saved my work!!! I got a very helpful solution. Thanks a lot!!!!

Re: Color/size by Expression in Charts

abhalla2 — Sun, 28 Apr 2019 09:40:58 GMT

There are 2 measures for scatter plot one for X-axis and another for Y-axis, just add the third and that would be treated as Bubble size expression

Hope this would help!