Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
leozilio
New Contributor

KML is not working - what can I do?

Hi dear,

I have two .kml files (from Sao Paulo state, Brazil - attached). In one of them, I have two informations (City ID and Polygon) and into another one I have two more infos (City ID, and City Name). I must cross all this informations and make some maps with another Excel file, which I have prices and quantities data.

My problem is that Qlik Sense is not reading correctly my .kml files (or, which is more probable, I am not able to make the correct update of the files). Once I Add data, I am trying to build the map but a "No result" masage came in my screen.

Could please help me on this issue?

Thank you very much.

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: KML is not working - what can I do?

Hi Leonardo,

this is the LOAD script I created (see attachted app in previous post):

[sao-paulo_Poligonos]:

LOAD [ID],

     [Coordinates]

FROM [lib://Daten/sao-paulo_Poligonos.qvd]

(qvd)

Where len(ID)>0;

Tag field Coordinates with $geomultipolygon;

[sao-paulo_Atributos]:

LOAD [ID],

    [UF],

    [NomeMunicipio]

FROM [lib://Daten/sao-paulo_Atributos.qvd]

(qvd);

The important part is on line 8: Tag the field which contains the shape with $geomultipolygon


See: Field tags ‒ Qlik Sense

This what Sense do in background when loading from a KML file.


- Ralf

8 Replies
Khan_Mohammed
Honored Contributor II

Re: KML is not working - what can I do?

Which extension are you using to build a map?

Is it default Qlik Sense Map or any other extension object?

MVP & Luminary
MVP & Luminary

Re: KML is not working - what can I do?

Hi Leonardo,

do you have the original KML file?

- Ralf

MVP & Luminary
MVP & Luminary

Re: KML is not working - what can I do?

However, the QVD files are working for me:

leozilio
New Contributor

Re: KML is not working - what can I do?

Dear arvind654 and Ralf,

Thank you very much for your attention.

I actually made a mistake: as you see on the attached files, the extention is QVD, not kml. Sorry about that.

Ralf: What I need it's exactly what you did! Instead, I basically made the upload of the QVD files (Add data), but I can`t create a map - whrn I try to add a dimension, appears a "No results" mesage. Notwithstanding, I can create a table in which I can see both ID and Coordinates!! I can`t understand what is happening.

Could you please tell me which steps you did to create your map? Did you used only the QVD file to create your map or do you have another file (I am courious because in your map there are more information than Sao Paulo state...).

arvind654: those are the original files... sorry about the KML issue... I tried with some KML files too, but I am focousing on this QVD now. Do you think it is better another way?


Thanks once more.

MVP & Luminary
MVP & Luminary

Re: KML is not working - what can I do?

Hi Leonardo,

this is the LOAD script I created (see attachted app in previous post):

[sao-paulo_Poligonos]:

LOAD [ID],

     [Coordinates]

FROM [lib://Daten/sao-paulo_Poligonos.qvd]

(qvd)

Where len(ID)>0;

Tag field Coordinates with $geomultipolygon;

[sao-paulo_Atributos]:

LOAD [ID],

    [UF],

    [NomeMunicipio]

FROM [lib://Daten/sao-paulo_Atributos.qvd]

(qvd);

The important part is on line 8: Tag the field which contains the shape with $geomultipolygon


See: Field tags ‒ Qlik Sense

This what Sense do in background when loading from a KML file.


- Ralf

leozilio
New Contributor

Re: KML is not working - what can I do?

Hi Ralf, good morning.

Thank you very much! The script works perfectly.

I can understand better now: in ohter situation, handling a World map and an Brazilian map - but both KML - I didn't have any problem...

Thanks a lot.

My best regards

MVP & Luminary
MVP & Luminary

Re: KML is not working - what can I do?

Has this solved your problem? If so, please mak as "answered"..

leozilio
New Contributor

Re: KML is not working - what can I do?

Yes Ralf, solved and marked.

Thanks