Scatter Chart Map error

[#1]

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.

[hic]

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

[juleshartley]

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!

[#4]

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

[hic]

What do you use as expressions?

HIC

[#6]

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

[#7]

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

[hic]

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:

1. Do you have numeric values in all three expressions?
2. Do you have other values than 1 in the third expression?
3. 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