Map of the US

[Anonymous]

I want to use a map of the US to plot information for a contract. How do I load a jpg or gif to begin this process? Any help is appreciated.

[Anonymous]

Rob - I just visited the site - its great! Thanks for the help and additional information which is wonderful for a novice like myself.

Myrna

[Anonymous]

Rob I was unable to open the heatmap example in the cookbook. It gives an error message. Is there another way to view the document?

[#4]

I've tried this approach and seem to be having issues with the Google key. There are several options for me to cut and paste. Should I wrap my key with any specific text? Any help would be greatly appreciated.

[#5]

Here is my script:

/ Google Maps in QlikView

// V0.85.2 - October 1st 2008 © Copyright QlikTech International AB 2008 / AES

// Google Maps Key

// get a key here http://code.google.com/apis/maps/signup.html

gmap_key = 'ABQIAAAAVrbMgl0F4aFU6phEkXwkFxTSO7tnPFawO4hExAF0Hd8Og_hF1BTMs_sefzASmG0N3MtAf82urOLBBA';

max_zoom_level = 17;

//maximum value 17

// Variables required for calculating map

// No need to change these

var_pi180= '=pi()/180';

var_lat_offset= '0';

var_mc2= '=256*pow(2,$(var_zoom))';

var_mc1= '=256*pow(2,($(var_zoom)-1))';

var_mid_lat= '=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';

var_mid_long= '=min(longitude)+(max(longitude)-min(longitude))/2';

var_zoom= '=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))';

var_maptype= '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';

map_size_x= '640';

map_size_y= '400';

SET

HidePrefix='_'

;

// Field required for calcualting best zoom level

_zoom_level:

Load

RecNo( ) as _zoom_level autogenerate(max_zoom_level)

;

maptype:

LOAD

* INLINE

[

;

LOAD

* INLINE

[

[#6]

Myrna - I don't think the state chart will give you what you need since you seem to be looking for an actual map with addresses.

[rwunderlich]

MCooks wrote:
Rob I was unable to open the heatmap example in the cookbook. It gives an error message. Is there another way to view the document?<div></div>

Are you using Personal Edition or a licensed edition? The Cookbook examples won't work with PE. If you are using a licensed edition, what was the error message? I have had occasional reports of trouble opening Cookbook files that have been corrected by downloading the Cookbook again.

-Rob

[Anonymous]

Rob I am using the licensed edition. I received a failure to open message. I did not have a problem with most of the other files in the cookbook.

[rwunderlich]

Try downloading the Cookbook again to see if that solves the problem.

-Rob

[Anonymous]

Rob - still the same failure notice. However, we were able to construct our map. The only remaining issue is trying to get the scatter dots to be different colors. We ahve tried to change them from the style tab but for some reason they are only black. It would be better if we could see the different locations idenfitied by different colors. Thank you for your help. Everyone who sent responses helped us tremendously. Thank you.

Myrna