2 Replies Latest reply: Jul 12, 2016 2:44 AM by Rahma khelifi RSS

    Problem with Google Map

    Rahma khelifi

      Hi all,

      I'm traying to load google map and I use this document that I have find in the communitySteps for beginners to implement Google Maps in Qlikview , I get tne neccessary data but when I try to create the chart I didn't get any information .

      Could same one explain me what is the problem ?



        • Re: Problem with Google Map
          Anil Babu Samineni



          Can you please share me the application which you creating for G Maps

            • Re: Problem with Google Map
              Rahma khelifi

              Sorry I didn't understand  What didi you mean by Application (I have alredy attached a print screen from my QlikView application ) and if you mean my script  :


              and this is the G map Script:

              // Google Maps Key
              // get a key here http://code.google.com/apis/maps/signup.html
              // gmap_key = 'xx';

              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
              Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

              LOAD * INLINE [

              set hideprefix = 'maptype';.

              As informatiom I have the complete adress of my clients (Street , Zip code ) if you have another suggestion , I will be pleased for that .