-
Re: Show Hide Extension
ishan Bhatt Oct 17, 2017 7:12 AM (in response to Nikhil Garg)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.
-
Re: Show Hide Extension
Nikhil Garg Oct 17, 2017 7:41 AM (in response to Nikhil Garg)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?
-
Re: Show Hide Extension
Shahbaz Khan Mohammed Oct 18, 2017 1:49 PM (in response to Nikhil Garg)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)
-
-
Re: Show Hide Extension
vikas mahajan Oct 18, 2017 12:04 PM (in response to Nikhil Garg)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
-
1.JPG 28.8 K
-
Re: Show Hide Extension
Nikhil Garg Oct 21, 2017 7:04 AM (in response to vikas mahajan)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?
-
City_StateMapping.xlsx 8.2 K
-
-
Re: Show Hide Extension
Nikhil Garg Oct 23, 2017 2:50 AM (in response to vikas mahajan)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?
-
Re: Show Hide Extension
vikas mahajan Oct 23, 2017 2:59 AM (in response to Nikhil Garg)PFA Sample
Vikas
-
Heat Map.qvf 598.5 K
-
Re: Show Hide Extension
Nikhil Garg Oct 23, 2017 3:48 AM (in response to vikas mahajan)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?
-
Re: Show Hide Extension
Nikhil Garg Oct 23, 2017 4:42 AM (in response to vikas mahajan)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?
-
Re: Show Hide Extension
Nikhil Garg Oct 24, 2017 2:12 AM (in response to vikas mahajan)Hey vikas,
Can you help me?
-
-
Re: Show Hide Extension
Nikhil Garg Oct 29, 2017 4:09 AM (in response to vikas mahajan)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?
-
Re: Show Hide Extension
vikas mahajan Oct 29, 2017 7:27 AM (in response to Nikhil Garg)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
-
Re: Show Hide Extension
Nikhil Garg Oct 29, 2017 7:56 AM (in response to vikas mahajan)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
-
Re: Show Hide Extension
vikas mahajan Oct 29, 2017 8:07 AM (in response to Nikhil Garg)attach sample application
-
Re: Show Hide Extension
Nikhil Garg Oct 29, 2017 8:22 AM (in response to vikas mahajan)Hey Vikas,
Pls find attached qvf. I ahve taken Sales Territory name.
In that pls select "Garbeta". It not shown in the map.
-
Re: Show Hide Extension
Nikhil Garg Oct 30, 2017 1:48 AM (in response to Nikhil Garg)vikasmahajan Do u get any clue?
-
Re: Show Hide Extension
vikas mahajan Oct 31, 2017 12:55 AM (in response to Nikhil Garg)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],
-
Re: Show Hide Extension
Nikhil Garg Oct 31, 2017 2:03 AM (in response to vikas mahajan)Hey Vikas,
Apologies but i didnt get you. Pls find my autogenerated script as attached and guide me what to do.
Thanks,
Nikhil Garg
-
AutogenrateScript.txt 3.6 K
-
-
-
-
Re: Show Hide Extension
Nikhil Garg Oct 30, 2017 1:49 AM (in response to Nikhil Garg)Hey mto,
Can you help me in this? ?I have attached a .qvf file as a sample application
-
-
-
-
-
-
-
-
-
-