Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

regarding maps

Hi..

I quickly need some help in maps because I am have presentation tomorrow.

My Question is:

we want to use maps for the locations of the hospitals and patients using latitude, longitude or Zip code, but when we trying to add or create dimensions it is showing us an error about some visualization.We have tried to resolve the error by seeing the video that's there in demo session but it did not work out.

So could anyone assist us in resolving that or is their any live chart option so that i can chat with them and resolve the problem. Please reply as soon as possible.

I am also attaching the screen shots please look at it and I am hoping that I could get the answer.

Thank you,

Alekhya

1 Solution

Accepted Solutions
Employee
Employee

Re: regarding maps

your .qvf did not attach - but see my attached .qvf with everything working.

Note this worked for me immediately without having to do anything with the data. Only because I assume the xls file was an export?

I assume you are getting your data from another source and this .xls file is not the original and just a sample?

You can force the Lat and Long to be numeric like this:

GeoMakePoint(num#(latitude),num#(longitude)) as LocationKey,

num#() - converts the type to numeric.

Is this what you are after? (click images to enlarge)

Note I use primary_city as my dimension.

LOAD

    zip,

    primary_city,

    state,

    county,

    GeoMakePoint(latitude,longitude) as LocationKey,

    country

    //"[Latitude Longitude]"

FROM [lib://Downloads/sample dsis.xlsx]

(ooxml, embedded labels, table is Location);

OR in your case:

LOAD

    zip,

    primary_city,

    state,

    county,

    GeoMakePoint(#num(latitude),#num(longitude)) as LocationKey,

    country

    //"[Latitude Longitude]"

FROM [lib://Downloads/sample dsis.xlsx]

(ooxml, embedded labels, table is Location);

I believe one of you coordinates may be off - as it is showing Alexandria in France.

Let us know how you do.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
18 Replies
Not applicable

Re: regarding maps

I have the same problem. However, the solution is the addition of Google Maps for QlikSense. ZIP archive contents should be placed in the extensions directory. (Documents / Qlik / Sense / Extensions /) and QVF file in the directory with applications (Documents / Qlik / Sense / Apps /).

Link to the ZIP archive with Extension: http://www.superwarto.pl/Sense/GoogleMaps-Sense.zip

Link to the sample application: http://www.superwarto.pl/Sense/GoogleMaps.qvf

To add a map to be added in one field coordinates.

Format of the field:

[latitude longitude] for example: [52.2296756 21.012228700000037]

In the Data Load Editor you must use function GeoMakePoint to create field with Coordinates, for example:

GeoMakePoint(latitude,longitude) as coordinates;

Employee
Employee

Re: regarding maps

Hello Alekhya,

You are using GeoMakePoint() - with your Lat and Long fields as described in the videos: Using the Maps Chart Object - Points Maps - Part 1 - (video) correct?

In your screenshot - I don't see your location key field such named as coordinates as Bart described above. (you may have named it something else, I could not tell)

First verify that (see attached example) - copy .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps  and refresh with F5.

THEN - If you are using it correctly and you are still getting this issue - then it may be an issue with your Latitude and Longitude field.

Can you put them in a table object and see if there are all right aligned?

Make it look like this: (note they are right aligned, indicating they are numeric) - if you have a mix of left and right aligned fields - your Lat and Long may need further transformation.

If you got to the data model viewer - see if the Latitude and Longitude fields are listed as $numeric.

Let us know how you do.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Not applicable

Re: regarding maps

Hi..

I have tried by adding the field that you have mentioned but I cannot see the dimensions displayed in the dimensions of the map.

Not applicable

Re: regarding maps

Hi...

It is showing the same error that the action I am attempting cannot be used for the vizualization

Employee
Employee

Re: regarding maps

Hi Alekhya - I see the answer was marked as correct, but you then replied that you are still having an issue. Are you you still having a problem? Please attach sample data and .qvf app so we can take a look further.

Regards,

Mike

Regards,
Mike Tarallo
Qlik
Not applicable

Re: regarding maps

How to change the Latitude and Longitude fields are listed as $numeric because it is showing me in preview $ascii$text.

Not applicable

Re: regarding maps

C:\Users\ALEKHYA\Documents\Qlik\Sense\Apps\DSIS.qvf

Employee
Employee

Re: regarding maps

your .qvf did not attach - but see my attached .qvf with everything working.

Note this worked for me immediately without having to do anything with the data. Only because I assume the xls file was an export?

I assume you are getting your data from another source and this .xls file is not the original and just a sample?

You can force the Lat and Long to be numeric like this:

GeoMakePoint(num#(latitude),num#(longitude)) as LocationKey,

num#() - converts the type to numeric.

Is this what you are after? (click images to enlarge)

Note I use primary_city as my dimension.

LOAD

    zip,

    primary_city,

    state,

    county,

    GeoMakePoint(latitude,longitude) as LocationKey,

    country

    //"[Latitude Longitude]"

FROM [lib://Downloads/sample dsis.xlsx]

(ooxml, embedded labels, table is Location);

OR in your case:

LOAD

    zip,

    primary_city,

    state,

    county,

    GeoMakePoint(#num(latitude),#num(longitude)) as LocationKey,

    country

    //"[Latitude Longitude]"

FROM [lib://Downloads/sample dsis.xlsx]

(ooxml, embedded labels, table is Location);

I believe one of you coordinates may be off - as it is showing Alexandria in France.

Let us know how you do.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: regarding maps

Hey,

It's great that you are sharing the Google Maps extension but please don't post the zip. Instead try to link to either Branch or Github directly, for this extension this thread on Branch http://branch.qlik.com/projects/showthread.php?487-GoogleMaps

If I make any updates to the extension (which I do/will) the zip won't get updated so it's better to always grab extensions from the source.

Community Browser