23 Replies Latest reply: Oct 21, 2016 3:09 PM by Shahbaz Khan Mohammed RSS

    Map object

    Babina Pradhan

      Hi All,

      I am using the free qlik cloud version for creating map but for some of the location the bubble is not showing in the right location as for example Rochester, NY and also Greenville, SC.

       

      Also how do I change the color for the particular bubble.

       

      Thanks in advance.

        • Re: Map object
          Shahbaz Khan Mohammed

          If the bubble is not showing on map it means you have no data for those states.

          For the color coding you can do it by >Properties>Colors and Legends>Color by Custom> By expression>

          Enter your desired expression to get colors you want.

           

          Can you share a sample date and what colors you trying to achieve with what fields?

           

          Thanks.Map.png

          • Re: Map object
            Babina Pradhan

            Currently the chart is being displayed like this using custom color the expression being used is sum(Audit rating) and dimension being the City. The bubble color needs to be according the audit rating just as 1 is Yellow, 2 is Green and 3 is Red.

            Further, if there are multiple data for lets suppose Greenville then the rating is being added I tried using just the Audit Rating as the expression but it is changing the size of the bubbles as below.

            *I used the expression in the custom color in the expression section which is giving error.

            =if(([7.Audit Rating])='1'], Yellow(),
            if([7.Audit Rating]='2'], Green(),
            if([7.Audit Rating]='3'], Red())))

              • Re: Map object
                Shahbaz Khan Mohammed

                Map1.png

                 

                Map1.png

                 

                 

                I used

                if(Audit='1', Yellow(),

                if(Audit='2', Green(),

                if(Audit='3', Red(),

                if(Audit>'3',Blue()))))

                 

                And to adjust the bubble size

                Properties>Layers>Point Layer>Below you'll find bubble size slider

                Adjust that slider to adjust the bubble size.

                 

                Maybe use this one

                 

                =if([7.Audit Rating])='1', Yellow(),

                if[7.Audit Rating]='2', Green(),

                if[7.Audit Rating]='3', Red())))


                Try the above expression for your color code, check the ] which is not needed I guess, hence you getting error I suppose.

                Note: Multiple states has same audit Number....

                Like FL,IL,IN has audit number 2 and if you select those states it will only show Green. For your multiple data sets, if I understood it correctly.

                  • Re: Map object
                    Babina Pradhan

                    Hi Shahbaz,

                    The color for the specific  rating did work but for bubble size the bubble slider worked as well thanks for the suggestion. But  for some reason some of the location for the bubble is not showing in the right location as for example Rochester, NY and also Greenville, SC.I am currently using the free cloud version of QlikSense.

                    Thanks so much.

                      • Re: Map object
                        Shahbaz Khan Mohammed

                        I do not think there is any difference for a developer if he/she is using Qlik Sense Desktop or Cloud.

                        Cloud is used like an environment to host apps for other users but everything else is same, I've never used Cloud but Qlik Sense has no different function for Desktop or Cloud or Hub unless you trying to implement Section Access, which can be done only on Server. (developer point of view)

                         

                        The bubbles not pointing on correct location might be cus of wrong Latitude and Longitude.

                         

                        Check the Latitude and Longitude for Rochester, NY & Greenville, SC in your data and verify it with by searching on google.

                        Rochester, NY : 43.1610, -77.6109

                        Greenville, SC : 34.8526, -82.3940

                        Above are Lat & Long from Google search, verify it with your lat and long in data. If it is an XL file, change it. If it is coming from a source db then ask the concerned person to verify it.

                         

                        Thanks.

                         

                          • Re: Map object
                            Babina Pradhan

                            Hi arvind654,

                            Thanks for your response. The latitude and longitude used is as below. I verified in google that is the lat and long for the specified location. I see that you have used - in the second coordinate do you that should make a difference. I see in the map for all other location the bubble is at a exact location except for the sited below which is confusing.

                            Rochester, NY :

                               

                            43.1610° N, 77.6109° W

                            Greenville, SC :

                               

                            34.8526° N, 82.3940° W