Syntax Error

[#1]

Hi

I am Siddhartha and I have recently started working on Qlik Sense. I have been trying to get the maps functionality working but when I try to insert the GeoMakePoint function in the script load editor, I am getting the following error:

syntax error, missing/misplaced FROM: [Sheet1]: LOAD [State], [Latitude], [Longitude] GeoMakePoint[Latitude,Longitude]as Coordinates FROM [lib://cydhartgawtam/Geography.xlsx] (ooxml, embedded labels, table is Sheet1): [Sheet1]: LOAD [State], [Latitude], [Longitude] GeoMakePoint[Latitude,Longitude]as Coordinates FROM [lib://cydhartgawtam/Geography.xlsx] (ooxml, embedded labels, table is Sheet1)

Please advice if I am doing something wrong.

Cheers

Siddhartha

[roger_stone]

Can you post the appropriate portion of your script?

[Anonymous]

You are missing space before as

try like this:

GeoMakePoint[Latitude,Longitude] as Coordinates

[#4]

Hi Roger

Please find below the script:

[Sheet1]:

LOAD [State],

           [Latitude],

           [Longitude],

  GeoMakePoint[Latitude,Longitude]as GeoKey;

FROM [lib://cydhartgawtam/Geography.xlsx]

(ooxml, embedded labels, table is Sheet1);

[tresB]

Perhaps a comma is missing (and a space between']' and 'as' ). Try like:

LOAD [State], [Latitude], [Longitude] , GeoMakePoint[Latitude,Longitude] as Coordinates FROM

[#6]

Hi Balraj

I tried the space option but I still got the erro.

[#7]

hi Guys

I changed the [ to ( in the geomakepoint function and I was able to load the data. Thank you for all your help.

Cheers

Siddhartha

[roger_stone · Accepted solution]

GeoMakePoint is a function, so you need parentheses:

GeoMakePoint(Latitude, Longitude) AS Coordinates

[Anonymous]

Try Roger Suggestion

[reddy-s]

Hi Siddhartha,

Do you have a semicolon at the end of Geo key. If so, you need to remove it as well.