topic Re: Scatter Chart Map error in QlikView

Scatter Chart Map error

Thu, 12 Jun 2014 10:11:09 GMT

Hello

I have set up Scatter Chart Maps previously on Qlikview apps and they work correctly.

However, the latest one I have set up, will only display bubbles where single visits have taken place at a property. It will not display a bubble for properties which have had more than one visit.

Does anyone know how to overcome this, so that all properties in the sample are displayed on the Scatter Chart Map.

Re: Scatter Chart Map error

hic — Thu, 12 Jun 2014 10:14:23 GMT

You probably don't have an aggregation function - like Avg(...) - in your expressions. You need that to calculate the position of the bubble when there is more than one value.

See

http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/18/scatter-chart

HIC

Re: Scatter Chart Map error

juleshartley — Thu, 12 Jun 2014 10:23:46 GMT

Was just writing a reply when Henric answered... and I have a rule that if Henric, Gysbert, John W and a few others answer a post, then there's not much point adding to it - it's likely to be the right answer!

Re: Scatter Chart Map error

Thu, 12 Jun 2014 13:01:11 GMT

Hi Henric

Thanks for your advice. I've read through the two links, tried them (and a whole host of other permutations), but still no joy.

Takk

Mike

Re: Scatter Chart Map error

hic — Thu, 12 Jun 2014 14:43:09 GMT

What do you use as expressions?

HIC

Re: Scatter Chart Map error

Thu, 12 Jun 2014 14:50:07 GMT

Hi Henric

I have tried using Sum or Count. But I either just get no bubbles on the map, or bubbles for when 1 visit only has been made to a property.

Regards

Mike

Re: Scatter Chart Map error

Wed, 25 Jun 2014 11:58:57 GMT

Hi Henric,

I am a collegaue of Mike - reference to original post.

I have had a look at this too. Followed the steps to ensure 'advanced mode' is selected.

On the expressions tab there is the following 3 with the associated 'definition':

Longitude:sum( round (256*pow(2,($(var_zoom)-1)))+( Longitude *((256*pow(2,$(var_zoom)))/360)))

Latitude : sum(256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))

=[Address Concat] : Count([Address Concat]) - adress concat is the address the repair has took place (unique identifier as it were).

Are we missing something? As Mike said bubbles appear but they are all the same size.

Chris

Re: Scatter Chart Map error

hic — Wed, 25 Jun 2014 12:30:02 GMT

Not seeing the data, it is impossible to tell where the problem is.

To debug, I would convert it to a pivot table and check the following:

Do you have numeric values in all three expressions?
Do you have other values than 1 in the third expression?
Do you have NULL values in the dimension?

Further, I would check on the "Style" tab that a style that can show different bubble sizes is chosen.

HIC