https://community.qlik.com/t5/QlikView/Mapbox-issue-with-coordinates/m-p/1706363#M455616 <P>Hi there</P><P>We managed to get mapbox working in Qlikview&nbsp; by using a chart with a map background. Unfortunately something is going wrong with the conversion of coordinates to X,Y positions on the map. In the attached image you'll see that the distance between the scatter points is OK but it's on a wrong location of the map. Therefore my conclusion is that something is wrong in the formula. This is currently set up like this:</P><P>Expression: Longitude</P><LI-CODE lang="markup">=( round(256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )</LI-CODE><P>Expression: Latitude</P><LI-CODE lang="markup">=( ((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))) )</LI-CODE><P>Expression Metric:</P><LI-CODE lang="markup">sum(_Turnover)</LI-CODE><P>&nbsp;</P><P>Any mathematical geniuses out here that can see why this is not working? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 18:34:31 GMT Arnec 2024-11-16T18:34:31Z https://community.qlik.com/t5/QlikView/Mapbox-issue-with-coordinates/m-p/1706363#M455616 <P>Hi there</P><P>We managed to get mapbox working in Qlikview&nbsp; by using a chart with a map background. Unfortunately something is going wrong with the conversion of coordinates to X,Y positions on the map. In the attached image you'll see that the distance between the scatter points is OK but it's on a wrong location of the map. Therefore my conclusion is that something is wrong in the formula. This is currently set up like this:</P><P>Expression: Longitude</P><LI-CODE lang="markup">=( round(256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )</LI-CODE><P>Expression: Latitude</P><LI-CODE lang="markup">=( ((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))) )</LI-CODE><P>Expression Metric:</P><LI-CODE lang="markup">sum(_Turnover)</LI-CODE><P>&nbsp;</P><P>Any mathematical geniuses out here that can see why this is not working? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 18:34:31 GMT https://community.qlik.com/t5/QlikView/Mapbox-issue-with-coordinates/m-p/1706363#M455616 Arnec 2024-11-16T18:34:31Z