I have converted many full addresses into coordinates of the formula [x, y] via a different tutorial and I know thy are correct. I can copy paste and single one of them into google and it comes up with the correct location. Following a different tutorial, I ended up with the following script (the stuff I added bracketed in red):
From here, I went into my sheet and opened a map and added coordinates (with no little black earth next to the name) as a dimension. For some reason, nearly all of my coordinates are popping up in Antarctica. What am I doing wrong here? I've attached a simplified version of my document. I really appreciate any help I can get on this. Bad map also shown below:
When you're right you're right! Separating the coordinates into 2 separate fields resolved the problem and allow qlik to piece them together separately on it's own. Didn't even have to do any script editing. Thanks.