20 Replies Latest reply: Oct 31, 2017 2:03 AM by Nikhil Garg

Show Hide Extension

Nikhil Garg Oct 17, 2017 6:50 AM

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

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.
Like Show 0 Likes (0)

Actions
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?
Like Show 0 Likes (0)

Actions
- 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)
  Category:SVG maps of India - Wikimedia Commons
  
  Like Show 0 Likes (0)
  
  Actions
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
Like Show 0 Likes (0)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions
- 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?
  
  Like Show 0 Likes (0)
  
  Actions
  - 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
    
    Like Show 0 Likes (0)
    
    Actions
    - 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?
      
      Like Show 0 Likes (0)
      
      Actions
    - 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?
      
      Like Show 0 Likes (0)
      
      Actions
    - Re: Show Hide Extension
      
      Nikhil Garg Oct 24, 2017 2:12 AM (in response to vikas mahajan)
      
      Hey vikas,
      Can you help me?
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: Show Hide Extension
        
        vikas mahajan Oct 29, 2017 3:44 AM (in response to Nikhil Garg)
        
        Statewise Heat Map for India in Qliksense    use this KML
        
        Vikas
        
        Like Show 0 Likes (0)
        
        Actions
        
        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?
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Show Hide Extension
        
        vikas mahajan Oct 29, 2017 8:07 AM (in response to Nikhil Garg)
        
        attach sample application
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        c1f78b85-0b93-41d6-bb0f-263ccea1198b.qvf 320.0 K
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Show Hide Extension
        
        Nikhil Garg Oct 30, 2017 1:48 AM (in response to Nikhil Garg)
        
        vikasmahajan Do u get any clue?
        
        Like Show 0 Likes (0)
        
        Actions
        
        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],
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions