Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Kml Europe

I'm looking for a kml file covering Europe. I found a world map here in this community but can't find a proper Europe map. Any suggestons ?

1 Reply
Not applicable

Re: Kml Europe

Hi,

You can load first an INLINE table only with the countries of Europe and then load the KML file filtering the Countries with a "WHERE EXISTS(Country, Country_intheKML)" sentence.

Countries:

LOAD * INLINE [

    Country

    Spain

    Portugal

    France

    Italy

];

LOAD

    World.Name as Country,

    World.Area as Country_poly

FROM 'lib://Downloads/World.kml'

(kml, Table is [World/Features])

where Exists(Country, Country);

Capture.PNG

Community Browser