Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

How to Implement Heat Map on Qliksense

Good day everyone,

I need to develop a heat map on qliksense using the Nigeria map as the map as well as showing all the states in the map.

The state area on the map will be used as the dimension against total number of students.

Can anyone help me with the clue..

Although I have done a heat map using xml.code... but how can I do that for Nigeria.

See attached for desired map (Nigeria)..

Regards 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

1. Download a KML file for Nigeria States. For example, from here Download | Global Administrative Areas.I used the "Level 1" data for this example. Files downloaded from this site are in archive format and will need to be unzipped using a tool like 7Zip.

2. Drag the extracted KML file to your Qlik Sense application.

3. Load your student data, using the same name for the state that the KML load used. In this example, [NGA_adm1.Name]. (Note: you can modify the KML load to use a fieldname you are already using like "State").

4. Create a Map object in your Qlik Sense app. Use [NGA_adm1.Name] for the Dimension. Select "Area" when prompted.

5. In the Appearance section of the map properties, provide your Student aggregation (like "Sum(Students)") as the color by expression and select a color scheme.

2017-02-27_18-06-56.png

That's it. You have some options to mess with as far as color schemes and how you want the Students to be bucketed or not. Example qvf attached.

2017-02-27_18-09-32.png

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

3 Replies
MarcoWedel

Hi,

maybe helpful:

QlikCommunity_Thread_251409_Pic1.JPG

regards

Marco

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

1. Download a KML file for Nigeria States. For example, from here Download | Global Administrative Areas.I used the "Level 1" data for this example. Files downloaded from this site are in archive format and will need to be unzipped using a tool like 7Zip.

2. Drag the extracted KML file to your Qlik Sense application.

3. Load your student data, using the same name for the state that the KML load used. In this example, [NGA_adm1.Name]. (Note: you can modify the KML load to use a fieldname you are already using like "State").

4. Create a Map object in your Qlik Sense app. Use [NGA_adm1.Name] for the Dimension. Select "Area" when prompted.

5. In the Appearance section of the map properties, provide your Student aggregation (like "Sum(Students)") as the color by expression and select a color scheme.

2017-02-27_18-06-56.png

That's it. You have some options to mess with as far as color schemes and how you want the Students to be bucketed or not. Example qvf attached.

2017-02-27_18-09-32.png

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

MarcoWedel

Please close this thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco