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.
vikasmahajan
Esteemed Contributor

Statewise Heat Map for India in Qliksense

Hi all,

I want to create a Statewise Heat Map for India in Qliksense using KML file. Please can some one guide how to create the same,

Thanks in adv

Vikas

1 Solution

Accepted Solutions
shwetagupta
Contributor II

Re: Statewise Heat Map for India in Qliksense

Hi Vikas,

If I am getting you correctly,

You can ingest Indian states kml file(as attached) rename state field as of your state field.

Somewhat like this:

Map:

LOAD

    Upper("India States.Name") as address_state,

    "India States.Point",

    "India States.Area"

FROM [lib://*****/India States.kml]

(kml, Table is [Indian_State - Copy.kml/Features]);


Please note field data of your field and kml should match (case wise)

After loading the data.
Use map as a chart > IndianState.Area (If you want to plot as area)

In Appearance, You can put your measure to colour. !

I hope this will help!

4 Replies
shwetagupta
Contributor II

Re: Statewise Heat Map for India in Qliksense

Hi Vikas,

If I am getting you correctly,

You can ingest Indian states kml file(as attached) rename state field as of your state field.

Somewhat like this:

Map:

LOAD

    Upper("India States.Name") as address_state,

    "India States.Point",

    "India States.Area"

FROM [lib://*****/India States.kml]

(kml, Table is [Indian_State - Copy.kml/Features]);


Please note field data of your field and kml should match (case wise)

After loading the data.
Use map as a chart > IndianState.Area (If you want to plot as area)

In Appearance, You can put your measure to colour. !

I hope this will help!

vikasmahajan
Esteemed Contributor

Re: Statewise Heat Map for India in Qliksense

Thanks for valueable reply.

Vikas

ascioneanna
New Contributor III

Re: Statewise Heat Map for India in Qliksense

Hi, someone can help me with this question?

Thank you Anna

area map for sales

nikhilgarg
Valued Contributor

Re: Statewise Heat Map for India in Qliksense

Hey Shweta,

Can you help me in this Making State boundary differ from existing state boundary ?

Community Browser