Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey vikas,
Can you help me?
Statewise Heat Map for India in Qliksense
Vikas
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?
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
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
attach sample application
Hey Vikas,
Pls find attached qvf. I ahve taken Sales Territory name.
In that pls select "Garbeta". It not shown in the map.
vikasmahajan Do u get any clue?
Hey mto,
Can you help me in this? ?I have attached a .qvf file as a sample application
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],