2 Replies Latest reply: Jan 16, 2018 2:35 AM by Patric Nordström RSS

    Pins are not coming if plotting pin by name and lat long together Qlik Sense Geoanalytic.

    DILIP SOLANKI

      Hi,

       

      We have some geographic regions as shown below:

      REgion.PNG

       

      Data load script:

      [Geo]:

      LOAD

      [Id] AS [Geo.Id],

      [Geo] AS [GeoName],

      [Latitude],

      [Longitude],

      [Status] AS [Geo.Status],

      GeoMakePoint([Latitude], [Longitude]) AS [Longitude_Latitude]

      FROM [lib://Desktop/SampleData.xlsx]

      (ooxml, embedded labels, table is Geo)

      WHERE [Status] = 'A';

       

       

      I want to plot all these geo's as bubble on map, so to achieve this in bubble layer. I am giving dimension as 'Geo'. Its perfectly working fine for some pins, but for some geo's pins are not plotting like ASGR (Austria, Switzerland,Germany).


      So in my Qliksense bubble layer, I have given below expression:

      =if(LEN(Longitude_Latitude)>0,Longitude_Latitude,GeoName)


      If Longitude_Latitude is not define then plot point based on GeoName else use lat long.

       

      When I am using above expression no bubble is appearing on map, but if am using any of the below given expression then points are showing on map.

      Longitude_Latitude  //Only ASGR will appear on map

      GeoName                  //Except ASGR all geo will appear on map


      So I just wanted to know is there any way through which we can plot these bubble on map by Geo Name and LatLong both?

       

      Thanks

      Dilip Solanki