Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of customers where I have compiled a list of latitude and longitidue coordinates. When I load them into qlikview, the values change. Qlikview is still able to interpret them correctly (i.e. i'm using the Google maps api to plot them on a map and it works).
for example:
My data I have Customer ABC Lat = 38.858262 Long = -99.293283
Qlikview changes it to Lat = 391.869733193811 and Long = 229.5657728
anybody know how to get qlikview to preserve the original format of my data?
hi,
Latitude:
LOAD * INLINE [
Customer, Latitude, Longitude
A, 38.858262, -38.858262
B, 39.858262, -39.858262
];
When I displayed the values in Pivot table, the values are shown as it is. When the format of the values are changing? Attach the file, so that it would easy to check the issue.
I"m newish to this forum. Do you want me to post the QVW file onto this forum? not sure how to do that.
You are correct. In the Pivot Chart view, I am also able to see the same values but when I put them onto my google maps api they come up as a strange format.