topic Bubble plot & color in QlikView

Bubble plot & color

Fri, 27 Nov 2009 03:18:12 GMT

Hi,

I would like to create a bubble plot with 2 informations : size is one (var1) , color is another (var2)

I know how to do it but for color I want to use some defined colors.

My question is how to transform sum(var2) directly in the graphic, in N classes (whatever the discretisation method) and after to assign a color with the ARGB funtion

For example : If F( sum(var2)) = 1 Then affect first color,

If F( sum(var2)) = 2 Then affect second color, etc...

Thanks for your help

Jean-Jacques

Bubble plot & color

prieper — Fri, 27 Nov 2009 03:51:10 GMT

Open the small "+" below the expression and enter the desired expression as above into "Background Colour" field.

HTH
Peter

Bubble plot & color

Fri, 27 Nov 2009 04:11:58 GMT

Yes i know the "+" but my problem is to affect a color automaticly.

I created a table in the script :
BlueColor:
Load * Inline [
Class , R , G , B
1 , 100 , 50 , 25 ,
2 , ....
];

In the graphic, I use an expression to transform sum(var2) in 1, 2 , ...

My problem is to link the result of the expression with BlueColor table.

Maybe you have a solution

Thanks anyway

Jean-Jacques

Bubble plot & color

prieper — Fri, 27 Nov 2009 16:45:26 GMT

The easiest approach would be to put the condition directly into the Background-option:

IF(SUM(val) > 10, RGB(255, 255, 0),
 IF(SUM(val) > 5, RGB(0, 255, 0),
 RGB(0, 0, 255)))

HTH
Peter