Qlik Community

Qlik Sense Cloud Discussions

Not applicable

Map with Alaska & Hawaii?

Hello - I am new to Qlik Sense and trying to create a map with Alaska and Hawaii adjacent to the continental U.S. Any suggestions on how to do this? Thanks.

1 Solution

Accepted Solutions
Employee
Employee

Re: Map with Alaska & Hawaii?

Hello Tom - here is the sample I promised as per your comment in the video.

You do this by loading different parts of the XML file using a WHERE condition as in:

[MAIN_LAND]:

LOAD

    [US States.Name] AS [STATE],

    [US States.Area] AS [US States.Area];

LOAD

[US States.Name],

[US States.Area]

FROM [lib://Map_data_and_kml/US States.kml]

(kml, Table is [US-States.shp/Features])

WHERE [US States.Name] <> 'HI' AND [US States.Name] <> 'AK'

;

[Alaska]:

LOAD

[US States.Name] AS [STATE],

[US States.Area] AS [US ALStates.Area];

LOAD

[US States.Name],

[US States.Area]

FROM [lib://Map_data_and_kml/US States.kml]

(kml, Table is [US-States.shp/Features])

WHERE [US States.Name] = 'AK'

;

[Hawaii]:

LOAD

[US States.Name] AS [STATE],

[US States.Area] AS [US HIStates.Area];

LOAD

[US States.Name],

[US States.Area]

FROM [lib://Map_data_and_kml/US States.kml]

(kml, Table is [US-States.shp/Features])

WHERE [US States.Name] = 'HI'

;

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
4 Replies
Employee
Employee

Re: Map with Alaska & Hawaii?

Hello Tom - here is the sample I promised as per your comment in the video.

You do this by loading different parts of the XML file using a WHERE condition as in:

[MAIN_LAND]:

LOAD

    [US States.Name] AS [STATE],

    [US States.Area] AS [US States.Area];

LOAD

[US States.Name],

[US States.Area]

FROM [lib://Map_data_and_kml/US States.kml]

(kml, Table is [US-States.shp/Features])

WHERE [US States.Name] <> 'HI' AND [US States.Name] <> 'AK'

;

[Alaska]:

LOAD

[US States.Name] AS [STATE],

[US States.Area] AS [US ALStates.Area];

LOAD

[US States.Name],

[US States.Area]

FROM [lib://Map_data_and_kml/US States.kml]

(kml, Table is [US-States.shp/Features])

WHERE [US States.Name] = 'AK'

;

[Hawaii]:

LOAD

[US States.Name] AS [STATE],

[US States.Area] AS [US HIStates.Area];

LOAD

[US States.Name],

[US States.Area]

FROM [lib://Map_data_and_kml/US States.kml]

(kml, Table is [US-States.shp/Features])

WHERE [US States.Name] = 'HI'

;

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: Map with Alaska & Hawaii?

By the way, I see you stated you are new to Qlik Sense, but I did see your comment on the creating a polygon map video, so I assume you got that part down ok, if not let me know. I also attached the sample data and kml file to this post.

Mike

Regards,
Mike Tarallo
Qlik
Not applicable

Re: Map with Alaska & Hawaii?

Thank you Mike! I will give it a try and let you know.

Many thanks...Tom

Not applicable

Re: Map with Alaska & Hawaii?

Hi Mike - just confirming that your solution worked perfectly!

Thanks again...Tom

Community Browser