Show Hide Extension

[nikhilgarg]

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

[nikhilgarg]

Hey vikas,

Can you help me?

[vikasmahajan]

Statewise Heat Map for India in Qliksense

Vikas

[nikhilgarg]

Hey Vikas,

I ahve used this KML only. But the problem is, under state West Bengal, there is Sales Territory Garbeta where some sales has been done. I can see it's data in a table in qliksense but i cannot locate this data on my map. What can be the reason?

[vikasmahajan]

check Upper(State) in your sales files and

Map:

LOAD

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

    "India States.Point",

    "India States.Area"

from KML file

This should solve your issue

Vikas

[nikhilgarg]

Hey,

I didnt get you. "Garbeta" is a territory inside state West Bengal. West Bengal is mapped and shown in my map but "Garbeta" is not showing in the map

[vikasmahajan]

attach sample application

[nikhilgarg]

Hey Vikas,

Pls find attached qvf. I ahve taken Sales Territory name.

In that pls select "Garbeta". It  not shown in the map.

[nikhilgarg]

vikasmahajan‌ Do u get any clue?

[nikhilgarg]

Hey mto‌,

Can you help me in this? ?I have attached a .qvf file as a sample application

[vikasmahajan]

Hi Nikhil

Try to create a load script with creating geo coordinate with  following command , I think your script is auto generating geo co-ordinates is creating issues. check your script with following command and use this field for mapping

GeoMakePoint([Latitude], [Longitude]) AS [Longitude_Latitude],