QlikTips #33: Google Maps are not working anymore in QlikView 10 SR2 ???

By Stefan Walther Comments closed
This entry was posted in Charts, Design & Layout, Development /QV Developer, Integration, QlikTips

This week I have received some eMails and read some posts that Google maps do not work anymore after upgrading to QV 10 SR2.

So after upgrading to QlikView 10 SR2 these maps could look like the following screenshot:

Google maps are not working anymore?

I have digged into this “problem” and the solution is quite simple:

  • Just check the transparency of your dynamic background image; if this is set to 100% (like in the example above) the dynamic image will be shown, but with 100% transparency :)

Set the transparency of the dynamic image to 0% !!!

After changing the transparency again to 0%, the map should work again:

Google Maps integration is finally working again as expected

Possibly related posts:

  1. QlikView 9 – Hyperlinks in Tabellendiagrammen
    Seit QlikView9 kann man in den Diagrammtypen „Pivottabelle“ und „Tabellendiagramm“ Hyperlinks definieren: Dazu stellt man in den Eigenschaften des Diagrammes unter „Formeln“ die Eigenschaft „Repräsentation“ auf „Hyperlink“. Dann kann den Link unter Definition nach folgender...
  2. QlikTip #35: Some hints on working with the QlikView Designer (Part 2 – Moving/Copying Objects)
    This is the second part of the series of articles summarizing some hints for working with the QlikView Designer. In this part I’ll show you what you need to know about “Moving/Copying objects” in QlikView....
  3. QlikTip #34: Some hints on working with the QlikView Designer (Part 1 – QlikView Designer)
    A colleague asked me today to promote the two blog-posts where the QV10 feature of moving objects while pressing the ALT-key is explained (see qlikboard.com and guerillabi.com). I thought instead of just posting these two...
Bookmark and Share
Published: April 29, 2011
and tagged , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

9 Comments

  1. agneray
    Posted May 1, 2011 at 08:00 | Permalink

    Hi,

    Sorry for my poor english…
    I would like how to migrate QlikView Server 10 SR1 to SR2 ? Is it very easy ? What’s happens with my tasks ?
    Thanks for advance,

    Pierrick

    • Stefan Walther
      Posted May 1, 2011 at 09:35 | Permalink

      Hi,

      yes it should be really easy … all your tasks should be available again on SR2 again because both SR1 and SR2 are using the same repository …

      But do not forget to backup the repository before updating 😉

      Regards
      Stefan

  2. Steve Dark
    Posted May 2, 2011 at 09:12 | Permalink

    HI there,

    Just to point out that I have also seen this issue in QV 10 SR 1. It caused a bit of head scratching the first time it reared it’s head! I presume it is only an issue with documents migrated from v9?

    Cheers,
    Steve

  3. mot1622
    Posted June 9, 2011 at 10:51 | Permalink

    Google Maps and QlikView offline
    hiiii

    im working in alikview with data in sql server (longitude and latitude) and i want represent in google earth inside qlikview .

    is there way to do that by kml file google maps.

    i need the step how do that with script code .

    thank you for support .

  4. Carlos Gutierrez
    Posted September 21, 2011 at 23:04 | Permalink

    Hi there,
    Sorry for my poor english.!!

    I want to publish Qlikview Apps on Google Sites, is that posible ????. Actually users can only access via Acces Point.
    Thanks for help
    Regards,

    • Stefan Walther
      Posted September 30, 2011 at 12:22 | Permalink

      Sorry, it is not exactly clear for me what you are trying to achieve …

      You have two possibilities to publish QlikView applications:

      – The QlikView-file itself (for offline usage); in this case every user would need a local QlikView client
      – If you are using the web client of QlikView you always need a QlikView Server/Webserver behind …

      Hope this helps!

      Regards
      Stefan

  5. Diego Adum
    Posted November 1, 2011 at 21:31 | Permalink

    Hi Stefan,
    I’m facing some problems with the locations on my map. Is like the values for Latin America are showed to east and values for Asia are showed to west. Something I noticed is when I center latin America on the map all the values belongs to Latin America are showed well (or better). I think my problem is related with the formula used to center the map. (I’m using the one that is being used on the Qlikview sample.)

    Longitude:
    =avg( round (256*pow(2,($(var_zoom)-1)))+( Longitude *((256*pow(2,$(var_zoom)))/360)) )
    Latitude:
    =avg(((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())))))
    Sum of tickets:
    =Dual(Country, sum({$} [Case Count]))

    String on the Dynamic Image=
    =’http://maps.google.com/staticmap?center=’
    & num(var_mid_lat, ‘##############’, ‘.’, ‘,’ ) & ‘,’
    & num(var_mid_long, ‘##############’, ‘.’, ‘,’ )
    & ‘&zoom=$(var_zoom)’
    & ‘&maptype=’&var_maptype
    & ‘&size=’&map_size_x&’x’&map_size_y
    & ‘&key=’&gmap_key & ‘.jpg’
    & ‘sensor=true_or_false’

    Script:
    // Google Maps in QlikView
    // V0.9 – 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 = ‘ABQIAAAA2bV_3zvH8IN-gNX92ByjgRSdapX2gNjAd7fDB7lOLcIRZhEleBSz9ZaixvLiWeauCbq9wsjh-DzpVA’;
    max_zoom_level = 5; //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= '800';
    map_size_y= '600';

    SET HidePrefix='_' ;
    // Field required for calcualting best zoom level
    _zoom_level:
    Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

    maptype:
    LOAD * INLINE [
    maptype
    roadmap
    mobile
    satellite
    terrain
    hybrid
    ];

    Thanks for your support!

  6. sergio
    Posted July 16, 2012 at 12:12 | Permalink

    Hi everyone,

    I’m new wirh Qlikview, and I have some help
    I have 2 objets 1) a years list box and the second a result list box and I want select one year from years list box and the result table showme the results <= to year selected

    How can I do IT?

    Thanks a lot.