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:
Latitude | Longitude |
---|---|
+31198782 | -084101689 |
+28623788 | -081127853 |
+33478138 | -082007668 |
It appears that QlikMaps is looking for these location codes in a format like this:
Latitude | Longitude |
---|---|
31.198782 | -08.4101689 |
28.623788 | -08.1127853 |
33.478138 | -08.2007668 |
Does anyone know a way to convert these codes into a format that QlikMaps can understand?
Hi Lawrence, you can try with num#() and strings concatenations:
=num#(Left(Longitude,3)&'.'&Mid(Longitude, 4),'#0.0000000', '.', ',')
Or, if all values have the same lenght:
Latitude/1e7 //1e7 = 10000000
Hi Lawrence, you can try with num#() and strings concatenations:
=num#(Left(Longitude,3)&'.'&Mid(Longitude, 4),'#0.0000000', '.', ',')
Or, if all values have the same lenght:
Latitude/1e7 //1e7 = 10000000
It appears that Longitude/1e6 works