KML is not working - what can I do?

[leozilio]

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.

[MK9885]

Which extension are you using to build a map?

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

[rbecher]

Hi Leonardo,

do you have the original KML file?

- Ralf

[rbecher]

However, the QVD files are working for me:

[leozilio]

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.

[rbecher · Accepted solution]

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]

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

[rbecher]

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

[leozilio]

Yes Ralf, solved and marked.

Thanks