Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Heat Map in Qlik sense?

Hi,

please suggest where those KML files for heatmap to be put in Qlik sense?

i want to create heatmap for State-City in india.

what is the steps for it.?

Please suggest in words as with videos.

1 Solution

Accepted Solutions
Michael_Tarallo
Employee
Employee

Hi Satish - see attached-  I had to download the actual level 1 KML file as I described in the process above. in this post. It is just easier to use the KML file and its boundary data this way. I don't think you can just use the boundary data in the file as it needs some other things when processing the actual KML file.

All I had to do was use this syntax:

UPPER(IND_adm1.Name) as state

So it would associate with the state field in your data.

These are for the names for states.

You most likely would need a level 2 KML as I described how to obtain in this post, if you want the city level and do the same thing.

Just copy the attached .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps  and refresh by pressing F5 or restart Qlik Sense Desktop.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members kow that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik

View solution in original post

11 Replies
tiago_hubner
Partner - Contributor III
Partner - Contributor III

Hi,

Yes mto‌ is correct.

For QlikView you can use this.

SVG Map Extension

Google Maps - Heatmap

I think this can help you.

Best Regards

robert99
Specialist III
Specialist III

Thanks

Assume this works with the built in sense map

Michael_Tarallo
Employee
Employee

Hello Tushar - the above suggestion by Tiago - is for QlikView not Qlik Sense - you may want to take a look at this video map series starting with video 1.

You can get KML files like this check out these steps:

NOTE:

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
Michael_Tarallo
Employee
Employee

Hi Robert - no what was provided by Tiagoo is for QlikView - see my response to Tushar, that should help you.

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
sspawar88
Creator II
Creator II
Author

mto

Hi Machael,

I have a excel for states of India with cities and respective order amount. as per you suggested i downloaded the KML for india but my excel having a state which is somewhere different spelled (due to my excel database mistake).

Datamodel matches the column name but data inside it looks different and not matches according to order amount.

have any way to do it?

Michael_Tarallo
Employee
Employee

Hi Satish - what are the values in the data and what are the values in the KML file?

You will find that in the KML tags something like this:

Placemark>

<name>AZ</name>

<Snippet></Snippet>

<description>

So AZ in my KML would have to match AZ in my data for the State field.

You may have to create a small table to link the two fields together. We call this a link table. Or you can create a lookup table to store the values.

LookUp Table: - You can do that inline in the load editor - or add it as another datasource

StateCodeKeyInMap
MyStateCode
AZ1AZ
FL2FL
GA3GA

Then you link the State code in Your data with the MyStateCode field in the lookup table and link the StateCodeKeyInMap with the State field in the KML file.

This will happen automatically as longs as the field names for each data field match.

I attached a sample for you too.

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
sspawar88
Creator II
Creator II
Author

mto

Hi Machael,

In my Database there is an 'state' field which having the name of states of india.

but these names & KML names are misspelled.

Below following columns in KML which i loaded in Qlik sense.

i have only loaded this kml file.

LOAD

    IND_adm1.Name,

    IND_adm1.Point,

    IND_adm1.Area

FROM [lib://TEMP/IND_adm1.kml]

(kml, Table is [India divisions. Level 1]);

Here i upload the image for two fields which have to be same data. but unfortunately different.

I also tried 'Upper' function to do it in capital letter but states in Database is already misspelled.


i'm not superior in Qlikview or Qlik sense. so please suggest in simple way.

thanks


state.png

Michael_Tarallo
Employee
Employee

Hi Satish, I see your dilemma - to get this to work - the data values need to match between the state values in the KML and the state values in your data.

Attach your data and the .kml to this discussion - use the advanced editor option in the upper right - and you can attach files.

let me take a look at it - this is basically a data transformation exercise - and we need to get the values matching. Please note that you will most likely need to use the link table I mentioned above in order to translate the incorrect data to the correct value.

Regards

Mike T

Regards,
Mike Tarallo
Qlik
its_anandrjs

@Satish,

Michael is right you have to do some transformation steps in the Qlik Sense editor on your load script and you can try with the functions like UPPER, Capatalise for this. As Michael says you need match those data then it will work for you better ways.

Regards,

Anand