Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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



Tags (1)
1 Solution

Accepted Solutions
roger_stone
Contributor III

Re: Syntax Error

GeoMakePoint is a function, so you need parentheses:

GeoMakePoint(Latitude, Longitude) AS Coordinates

9 Replies
roger_stone
Contributor III

Re: Syntax Error

Can you post the appropriate portion of your script?

balrajahlawat
Esteemed Contributor

Re: Syntax Error

You are missing space before as


try like this:

GeoMakePoint[Latitude,Longitude] as Coordinates

Not applicable

Re: Syntax Error

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

MVP
MVP

Re: Syntax Error

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

Re: Syntax Error

Hi Balraj

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

Not applicable

Re: Syntax Error

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

Re: Syntax Error

GeoMakePoint is a function, so you need parentheses:

GeoMakePoint(Latitude, Longitude) AS Coordinates

balrajahlawat
Esteemed Contributor

Re: Syntax Error

Try Roger Suggestion

reddys310
Honored Contributor II

Re: Syntax Error

Hi Siddhartha,

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