topic Re: Map Functionality in QlikSense? in QlikView

Map Functionality in QlikSense?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

On a scale between 1-10, I am about a 4 (with my Qlik Sense skills). Which means I am fairly new to Qlik and not super technical (but trying!).

I tried to find to find some Youtube tutorials without much luck and many folks talk about a KML file that I need to download.
Can someone please provide me step by step instructions on how to create a heat map? (I am used to the drag and drop functionality of tableau). I would like the ability to create a heat map and color it by the different hierarchical cuts of data (e.g. Region, District, Territory) based on the zipcodes.

Thanks so much!

Pauline

My file layout: An excel file that has Zipcode to Territory Mapping

Region District Territory Zipcode

East Mid-Atlantic New Jersey xxxxx

East Mid-Atlantic Philadelphia xxxxx

West Southeast Los Angeles xxxxx

Re: Map Functionality in QlikSense?

Oleg_Troyansky — Thu, 10 Nov 2016 21:58:05 GMT

Hi Pauline,

this might be a bit too much for a community post, but the good news are - it's described with a lot of detail, and with a hands-on example, in my book QlikView Your Business. Plus, you can learn many other valuable techniques that are applicable to both QlikView and Qlik Sense.

enjoy!

Oleg Troyansky

Re: Map Functionality in QlikSense?

Thu, 10 Nov 2016 22:28:55 GMT

A KML file contains Names & Longitude / Latitude ie.

<name>00014</name> // ZIP

The Longitude / Latitude coordinates make up the map outline or "polygonal shape" (useful keyword when googling).

To fill your requirement you'll need to find a KML that has US Zipcodes, discussed here

When loading your KML to QS you'll need to JOIN your data to the <name> field. & then use an expression to colour by Region, District or Territory.

Another term you may come across is SVG. SVG is a code based image file. There is a popular SVG reader for QS that could be tested with SVG files. However you may not get allot of support for these custom objects as people may not be familiar with the files & process.

Re: Map Functionality in QlikSense?

MK9885 — Fri, 11 Nov 2016 15:59:14 GMT

You cannot make a heat map in Qlik Sense for free.

Default Qlik Sense Map supports Bubble style map only, SVG supports polygon maps. (Free)

Google Maps support Heat Maps, Cluster Maps (Paid)

Qlik Maps support everything (Paid)

Geo Supports everything as well (Paid)

Ideally maps are created by taking Latitudes and Longitudes are data points on map. If it is Polygon map then the .SHP files or KML files.

By using bubble map you can also show kind of heat map (by coloring the bubbles depending on the measure value)

Same can be done to Polygon Maps (SVG).

Below is default Qlik Sense Map color coded

and this is your SVG Map can be color coded of course.

The above 2 Maps are totally free. Rest of other maps are not. But one of Polygon (SVG) and other is Bubble (Qlik Sense Map)