Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

Show Hide Extension

Hello All,

I am stuck in a situation in Qliksense.

I have Marketing Territory information like: Aali, Bodh Gaya etc.

For Ali as Marketing Territory, Bhubaneswar is the Sales Territory.

For Bodh Gaya as Marketing Territory, Sasaram is Sales Territory.

I dont have any KML file, so i drag and drop the Qvd(having Sales Territory and Marketing Territory information) and it automatically links only "Sales Territory field" with Geo Map and not "Marketing Territory field".

I want to show my map as follows:

1: In my map, i want to show only India Map and no other background countries.

2: In India map, by default(when nothing selected) i want to show States with boundaries.

3: If someone click on states, it will drill down to Marketing Territory Name(which unfortunately QlikSense Maps not able to recognise/link to geo map).

Can someone help me in this?

Thanks,

Nikhil Garg

20 Replies
ishanbhatt
Contributor II

Re: Show Hide Extension

Hi Nikhil,

Do you use KML file for Indian region? Map your field values with KML file. After this make Geo Key in script.

may be this will fulfill your requirements.

nikhilgarg
Contributor III

Re: Show Hide Extension

Hey Ishant,

I tried finding KML files for India and got one but it has Point and Name columns empty. Can you help me in this?

Also, do i require 3 different KML files for India's States, Sales Territory and Marketing Territory?

vikasmahajan
Honored Contributor III

Re: Show Hide Extension

1. Create Heat Map for India ->StateWise  Map like this (refer Attached file 1)

2. Create other graph district wise which will point area chart and on bubble you can show dist wise

    Sales or any measure you want.

3. You can download show hide extension download this extension and copy into c:\qliksense\extension folder

4. Go to master items -> Visualizations   -> Drag this 2 charts in master items.

5. Drag extension -> Set default Map as statewise map,

6  Give condition hide like this is given in extension example refer that.

This way you can achieve this

Vikas

Khan_Mohammed
Honored Contributor II

Re: Show Hide Extension

Try SVG Map extension in Qlik Sense

They might have static India map tored already once you install the extension.

If they do not then you can download it and add it to the extension (Place the downloaded svg file into the SVG folder)

CategorySmiley FrustratedVG maps of India - Wikimedia Commons

nikhilgarg
Contributor III

Re: Show Hide Extension

Hey Vikash,

Thanks for your  reply. Will try it and let you know asap. But i also tried one thing:

I make an excel having city and state. Pls find attached file. When i drag and dropped the file and reload data, "state column" is not recognised as a column to add as dimension in maps in qliksense. Pls let me know how to resolve this?

nikhilgarg
Contributor III

Re: Show Hide Extension

Hello Vikash,

I tried creating India map state wise using your kml file in Qlik Sense Area Map India->State -> District

but i am unable to create India map statewise. Can you help me in this?

vikasmahajan
Honored Contributor III

Re: Show Hide Extension

PFA Sample

Vikas

nikhilgarg
Contributor III

Re: Show Hide Extension

Thanks Vikas for your help. I tried searching the KML file for indian states and territories but could not find any. Can you share the kml file that you ahve used in your HeatMap.qvf?

nikhilgarg
Contributor III

Re: Show Hide Extension

Thanks Vikas for your help. I tried searching the KML file for indian states and territories but could not find any. Can you share the kml file that you have used in your HeatMap.qvf for states and districts?

Community Browser