topic Re: Bubble size in QlikView

Bubble size

ravindraa — Mon, 30 Nov 2015 06:25:48 GMT

Hi all,

I have struck in place please give me suggestion to come out on this.

I have crated scotter chart my expression sum(Polarity), and count (CustID) i want to display bubble's size based on the sum(Polarity)wise. In Expression tab i have given two expresion and bubble size expression also. Here the problem is my bubble are changing for positive values but bubble are not showing for negitive values.

What i have to do to change for negative values.

Thanks in advance.

thanks & Regards

Ravindra

Re: Bubble size

nagarjuna_kotha — Mon, 30 Nov 2015 06:37:50 GMT

Hi Ravi,

Can you attach sample file ?

-Nagarjuna

Re: Bubble size

tresB — Mon, 30 Nov 2015 06:40:54 GMT

Negative size - is not feasible. Hence, you don't see any bubble for them. Alternatively you can take absolute values of the negatives using fabs(), and possibly use a some fixed disdinct color (background of the bubbles) for negative values to distinguish from others.

Re: Bubble size

jonathandienst — Mon, 30 Nov 2015 06:45:16 GMT

You may need to clip the negative values to some low positive value (RangeMax(expr, n)), or display the absolute value (Fabs(expr)) using colour to show positive or negative values (although you would lose the legend value of the colours).

Is this the best possible visualisation pf the data? What are you trying to display? Is suggest that you post a sample qvw file, and details showing what you are trying to achieve.

Re: Bubble size

ravindraa — Mon, 30 Nov 2015 06:47:53 GMT

Hi ,

Please find the attached sample application and data file.

Re: Bubble size

ravindraa — Mon, 30 Nov 2015 06:51:09 GMT

Hi Tresesco/Jonathan,

Thanks for replaying i want to show the region wise scotter chart , in that chart i have to show negitive values also but the size should be change based on the Polarity wise .

Thanks& Regards

Ravi

Re: Bubble size

tresB — Mon, 30 Nov 2015 06:55:25 GMT

Something like attached sample?

Re: Bubble size

nagarjuna_kotha — Mon, 30 Nov 2015 06:56:50 GMT

Hi,

PFA...

Re: Bubble size

jonathandienst — Mon, 30 Nov 2015 06:57:52 GMT

Normally, the axes in a scatter chart are ordinal numerical values - in your example, your x-axis is a customer ID, which is not ordinal. So a scatter chart is almost certainly not the best visualisation for your data. I suggest that you think about what sort of question this chart should answer and come up with a better visualisation.

Re: Bubble size

tresB — Mon, 30 Nov 2015 07:01:59 GMT

Or, alternatively you can take the min value to to set - 10 (or a minimum value you need) and add up the value difference to the expression to maintain the relativity of the values (bubble sizes).

=Sum(Polarity)-$(=Min(Aggr(Sum(Polarity),Region)))+10