topic Formatting location codes for QlikMaps in QlikView https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84505#M13869 <HTML><HEAD></HEAD><BODY><P>I need to convert some location codes in a load script into a format that QlikMaps is able to render. I have longitude and latitude codes in the following format that does not work in QlikMaps:</P><P></P><TABLE border="1" class="jiveBorder" height="106" style="border: 1px solid #000000; border-image: none; width: 452px; height: 108px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Latitude</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Longitude</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">+31198782</TD><TD style="padding: 2px; text-align: center;">-084101689</TD></TR><TR><TD style="padding: 2px; text-align: center;">+28623788</TD><TD style="padding: 2px; text-align: center;">-081127853</TD></TR><TR><TD style="padding: 2px; text-align: center;">+33478138</TD><TD style="padding: 2px; text-align: center;">-082007668</TD></TR></TBODY></TABLE><P></P><P></P><P>It appears that QlikMaps is looking for these location codes in a format like this:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; border-image: none; width: 454px; height: 98px;" width="453"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Latitude</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Longitude</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">31.198782</TD><TD style="padding: 2px; text-align: center;">-08.4101689</TD></TR><TR><TD style="padding: 2px; text-align: center;">28.623788</TD><TD style="padding: 2px; text-align: center;">-08.1127853</TD></TR><TR><TD style="padding: 2px; text-align: center;">33.478138</TD><TD style="padding: 2px; text-align: center;">-08.2007668</TD></TR></TBODY></TABLE><P></P><P>Does anyone know a way to convert these codes into a format that QlikMaps can understand?</P></BODY></HTML> Sun, 25 Mar 2018 15:21:57 GMT lbunnell 2018-03-25T15:21:57Z Formatting location codes for QlikMaps https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84505#M13869 <HTML><HEAD></HEAD><BODY><P>I need to convert some location codes in a load script into a format that QlikMaps is able to render. I have longitude and latitude codes in the following format that does not work in QlikMaps:</P><P></P><TABLE border="1" class="jiveBorder" height="106" style="border: 1px solid #000000; border-image: none; width: 452px; height: 108px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Latitude</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Longitude</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">+31198782</TD><TD style="padding: 2px; text-align: center;">-084101689</TD></TR><TR><TD style="padding: 2px; text-align: center;">+28623788</TD><TD style="padding: 2px; text-align: center;">-081127853</TD></TR><TR><TD style="padding: 2px; text-align: center;">+33478138</TD><TD style="padding: 2px; text-align: center;">-082007668</TD></TR></TBODY></TABLE><P></P><P></P><P>It appears that QlikMaps is looking for these location codes in a format like this:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; border-image: none; width: 454px; height: 98px;" width="453"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Latitude</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Longitude</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">31.198782</TD><TD style="padding: 2px; text-align: center;">-08.4101689</TD></TR><TR><TD style="padding: 2px; text-align: center;">28.623788</TD><TD style="padding: 2px; text-align: center;">-08.1127853</TD></TR><TR><TD style="padding: 2px; text-align: center;">33.478138</TD><TD style="padding: 2px; text-align: center;">-08.2007668</TD></TR></TBODY></TABLE><P></P><P>Does anyone know a way to convert these codes into a format that QlikMaps can understand?</P></BODY></HTML> Sun, 25 Mar 2018 15:21:57 GMT https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84505#M13869 lbunnell 2018-03-25T15:21:57Z Re: Formatting location codes for QlikMaps https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84506#M13870 <HTML><HEAD></HEAD><BODY><P>Hi Lawrence, you can try with num#() and strings concatenations:</P><P>=num#(Left(Longitude,3)&amp;'.'&amp;Mid(Longitude, 4),'#0.0000000', '.', ',')</P><P></P><P>Or, if all values have the same lenght:</P><P>Latitude/1e7 //1e7 = 10000000</P></BODY></HTML> Sun, 25 Mar 2018 17:36:12 GMT https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84506#M13870 rubenmarin 2018-03-25T17:36:12Z Re: Formatting location codes for QlikMaps https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84507#M13871 <HTML><HEAD></HEAD><BODY><P>It appears that Longitude/1e6 works</P></BODY></HTML> Sun, 25 Mar 2018 20:36:54 GMT https://community.qlik.com/t5/QlikView/Formatting-location-codes-for-QlikMaps/m-p/84507#M13871 lbunnell 2018-03-25T20:36:54Z