topic Re: Google Maps and Set Analysis in QlikView

Google Maps and Set Analysis

bhelms — Wed, 15 Jan 2014 18:17:06 GMT

I am having a problem with integrating Google maps with set analysis. I want to be able to set the default zoom level based on a field and I am having a hard time figuring out where to do that.

Here is a picture of my chart:

When I select "Y" from the field "Current License Flag" here is what my chart looks like:

I want it to "select" that field without having to make the users acutally select it. I assume this is possible with set analysis but nothing I try is working. Thanks for the help.

Re: Google Maps and Set Analysis

Clever_Anjos — Wed, 15 Jan 2014 18:18:16 GMT

How is your zoom variable calculated?

Re: Google Maps and Set Analysis

bhelms — Wed, 15 Jan 2014 18:21:24 GMT

I simply left it at the defaults. I did try to add the set analysis in here, and it did change the zoom, but was in the middle of the ocean, not in the correct spot.

=max(aggr(if(max(round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))

Re: Google Maps and Set Analysis

bhelms — Thu, 23 Jan 2014 15:51:50 GMT

Anyone have any idea how to accomplish this?