Text to num

[fkeuroglian]

Hi expert

i have  a qvd where i have fields like latitude and longitude and i want to put in a map, my problem is that this fields are in TEXT format and the map do no recognize them as a number.

and when i try to pass in the script to NUM, nothing happend or pass wrong.

what could be?

i need the longitude and the latitude as a num

thank you a lot

Fernando

attached a qvw and the qvd i am using

thank you again!

[Miguel_Angel_Baeyens · Accepted solution]

Fernando,

Use the following in the script:

Num(Replace(latitude, '.', ',')) AS latitude

This happens because your regional OS settings and QlikView settings do not match.

In my computer, I can see the same behavior, because decimals in Spanish are separated by ',' and not '.'.

Miguel

[hic]

You use decimal comma but the source data has decimal points. Then you need to load the longitude and latitude like

  Num# (longitude , '#', '.', ',') as longitude

And you should do it before you store them in the qvd.

HIC

[fkeuroglian]

Muchas gracias Miguel

saludos

Fernando

[fkeuroglian]

Thank you Henric!