Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Not able to show Qlik Sense Map

Dear all,

I got a very simple file attached with latitude and longitude data.

I wonder why I'm not able to show data into Map .

Can someone gently to say if the file and format of data are correct ?

Why it don't work ?

Many thanks

Giò

4 Replies
Employee
Employee

Re: Not able to show Qlik Sense Map

Hi Giovanni,

It would work by adding GetMakePoint function to the load script as follows:

LOAD [CUSTOMER ID],

  [ADDRESS],

  [LATITUDE],

  [LONGITUDE],

  GeoMakePoint([LATITUDE],[LONGITUDE]) AS Location

FROM [lib://Downloads/GEO_GPS_TEST_VAL_ENGLISH.xls]

(biff, embedded labels, table is Foglio1$);

Not applicable

Re: Not able to show Qlik Sense Map

Hi Masaki,

thanks for your reply.

I did the same on my Desktop QSense but still I don't see any point.

Could it be becouse my is a testing license ?? Is it possible ? It sound strange.

On the worksheet is better to format using point or comma ??

XX.YYYYYYY

XX,YYYYYYY

Thanks

Not applicable

Re: Not able to show Qlik Sense Map

I have checked now in a table the uploaded data and effectively Locaton is empty.

This is the code I got and attached the result. I think there is something wrong geo.pngon formatting of latitude an longitude

LOAD

    [COD] AS CodCliente,

    [RAGSOC],

    [INDIRIZZO],

    [LATITUDINE] as Latitude,

    [LONGITUDINE] as Longitude,

    GeoMakePoint([LATITUDINE],[LONGITUDINE]) as Location

FROM [lib://CONTROLLO_GESTIONE/GEO_GPS_TEST_VALORI.xls]

(biff, embedded labels, table is Foglio1$);

Not applicable

Re: Not able to show Qlik Sense Map

Okey.... I got it !!!!

The only format working is using "," comma.... !!!! Thanks again