Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bubble plot & color

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

Labels (1)
3 Replies
prieper
Master II
Master II

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

HTH
Peter

Not applicable
Author

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

prieper
Master II
Master II

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