Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax Error

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



1 Solution

Accepted Solutions
roger_stone
Creator III
Creator III

GeoMakePoint is a function, so you need parentheses:

GeoMakePoint(Latitude, Longitude) AS Coordinates

View solution in original post

9 Replies
roger_stone
Creator III
Creator III

Can you post the appropriate portion of your script?

Anonymous
Not applicable
Author

You are missing space before as


try like this:

GeoMakePoint[Latitude,Longitude] as Coordinates

Not applicable
Author

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);

tresesco
MVP
MVP

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

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

Not applicable
Author

Hi Balraj

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

Not applicable
Author

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
Creator III
Creator III

GeoMakePoint is a function, so you need parentheses:

GeoMakePoint(Latitude, Longitude) AS Coordinates

Anonymous
Not applicable
Author

Try Roger Suggestion

reddy-s
Master II
Master II

Hi Siddhartha,

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