Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
please suggest where those KML files for heatmap to be put in Qlik sense?
i want to create heatmap for State-City in india.
what is the steps for it.?
Please suggest in words as with videos.
Hi Satish - see attached- I had to download the actual level 1 KML file as I described in the process above. in this post. It is just easier to use the KML file and its boundary data this way. I don't think you can just use the boundary data in the file as it needs some other things when processing the actual KML file.
All I had to do was use this syntax:
UPPER(IND_adm1.Name) as state
So it would associate with the state field in your data.
These are for the names for states.
You most likely would need a level 2 KML as I described how to obtain in this post, if you want the city level and do the same thing.
Just copy the attached .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh by pressing F5 or restart Qlik Sense Desktop.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members kow that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
Thanks
Assume this works with the built in sense map
Hello Tushar - the above suggestion by Tiago - is for QlikView not Qlik Sense - you may want to take a look at this video map series starting with video 1.
You can get KML files like this check out these steps:
NOTE:
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
Hi Robert - no what was provided by Tiagoo is for QlikView - see my response to Tushar, that should help you.
Mike Tarallo
Qlik
Hi Machael,
I have a excel for states of India with cities and respective order amount. as per you suggested i downloaded the KML for india but my excel having a state which is somewhere different spelled (due to my excel database mistake).
Datamodel matches the column name but data inside it looks different and not matches according to order amount.
have any way to do it?
Hi Satish - what are the values in the data and what are the values in the KML file?
You will find that in the KML tags something like this:
Placemark>
<name>AZ</name>
<Snippet></Snippet>
<description>
So AZ in my KML would have to match AZ in my data for the State field.
You may have to create a small table to link the two fields together. We call this a link table. Or you can create a lookup table to store the values.
LookUp Table: - You can do that inline in the load editor - or add it as another datasource
StateCodeKeyInMap | MyStateCode |
---|---|
AZ1 | AZ |
FL2 | FL |
GA3 | GA |
Then you link the State code in Your data with the MyStateCode field in the lookup table and link the StateCodeKeyInMap with the State field in the KML file.
This will happen automatically as longs as the field names for each data field match.
I attached a sample for you too.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
Hi Machael,
In my Database there is an 'state' field which having the name of states of india.
but these names & KML names are misspelled.
Below following columns in KML which i loaded in Qlik sense.
i have only loaded this kml file.
LOAD
IND_adm1.Name,
IND_adm1.Point,
IND_adm1.Area
FROM [lib://TEMP/IND_adm1.kml]
(kml, Table is [India divisions. Level 1]);
Here i upload the image for two fields which have to be same data. but unfortunately different.
I also tried 'Upper' function to do it in capital letter but states in Database is already misspelled.
i'm not superior in Qlikview or Qlik sense. so please suggest in simple way.
thanks
Hi Satish, I see your dilemma - to get this to work - the data values need to match between the state values in the KML and the state values in your data.
Attach your data and the .kml to this discussion - use the advanced editor option in the upper right - and you can attach files.
let me take a look at it - this is basically a data transformation exercise - and we need to get the values matching. Please note that you will most likely need to use the link table I mentioned above in order to translate the incorrect data to the correct value.
Regards
Mike T
@Satish,
Michael is right you have to do some transformation steps in the Qlik Sense editor on your load script and you can try with the functions like UPPER, Capatalise for this. As Michael says you need match those data then it will work for you better ways.
Regards,
Anand