14 Replies Latest reply: Apr 27, 2015 11:40 AM by Michael Tarallo RSS

    Heat Map in Qlik sense?

    Satish Pawar

      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.

        • Re: Heat Map in Qlik sense?
          Tiago Hubner

          Hi,

           

          Yes mto is correct.

           

          For QlikView you can use this.

          SVG Map Extension

          Google Maps - Heatmap

          I think this can help you.

           

          Best Regards

          • Re: Heat Map in Qlik sense?
            Michael Tarallo

            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

              • Re: Heat Map in Qlik sense?
                Satish Pawar

                mto

                 

                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?

                 

                  • Re: Heat Map in Qlik sense?
                    Michael Tarallo

                    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
                    AZ1AZ
                    FL2FL
                    GA3GA

                     

                    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

                      • Re: Heat Map in Qlik sense?
                        Satish Pawar

                        mto

                         

                        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


                         

                         

                         

                        state.png

                          • Re: Heat Map in Qlik sense?
                            Michael Tarallo

                            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

                              • Re: Heat Map in Qlik sense?
                                Satish Pawar

                                mto

                                 

                                Hi,

                                Here, i have uploaded one sample data from database.

                                please look at it.

                                 

                                 

                                Regards

                                Satish

                                  • Re: Heat Map in Qlik sense?
                                    Michael Tarallo

                                    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

                                • Re: Heat Map in Qlik sense?
                                  Anand Chouhan

                                  @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