Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

latitude and longitude format changed in qlikview

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?

3 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

I"m newish to this forum. Do you want me to post the QVW file onto this forum? not sure how to do that.

Not applicable
Author

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.