topic Re: Keep consistent color in bubble chart in QlikView

Keep consistent color in bubble chart

udaya_kumar — Thu, 07 Aug 2014 10:06:58 GMT

Hi,

I have a bubble chart, in which the dimension is dynamic.

Dimension changes based on the straight table below selected.

So if i have 5 values in a bubble chart, then i click one bubble, it filters to the selected value but the bubble color changes.
But i want it to be the same color as before.

How can we do that?

Re: Keep consistent color in bubble chart

qlikoqlik — Thu, 07 Aug 2014 10:14:07 GMT

you can fix the colour using the function RGB in the background color

Expand the dimension to see the option back ground colour

Thanks

Padma

Re: Keep consistent color in bubble chart

udaya_kumar — Thu, 07 Aug 2014 10:19:36 GMT

Hi,

Thanks for reply,

But my dimension is a variable, which updates based on selection of button below in the tool.

I have around 10 dimensions which changes in the bubble chart based on button selection below.

I guess i cannot include RGB for those dimensions.

Re: Keep consistent color in bubble chart

qlikoqlik — Thu, 07 Aug 2014 10:26:19 GMT

Please see the example: In my example I have fixed the colours for the dimension Fiscal Qtr if it is 51 or 52 else I have a different colour. This background colour should be set up in the expression not the dimension as I mention previously

if(Fiscal_Qtr=51,rgb(132,32,252),
if(Fiscal_Qtr=52,RGB(256,56,250),RGB(67,67,250)))

Thanks and regards

Padma

Re: Keep consistent color in bubble chart

udaya_kumar — Thu, 07 Aug 2014 10:29:52 GMT

Hi,

Thanks for the reply.

I have around 10 dimensions in the chart and 100's of values in those dimensions.

So i cannot hardcode values in the background color expression of dimension or expression.