topic Re: Text to num in QlikView

Text to num

fkeuroglian — Fri, 06 Mar 2015 12:28:10 GMT

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!

Re: Text to num

Miguel_Angel_Baeyens — Fri, 06 Mar 2015 12:34:01 GMT

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

Re: Text to num

hic — Fri, 06 Mar 2015 12:34:47 GMT

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

Re: Text to num

fkeuroglian — Fri, 06 Mar 2015 12:49:54 GMT

Muchas gracias Miguel

saludos

Fernando

Re: Text to num

fkeuroglian — Fri, 06 Mar 2015 12:50:27 GMT

Thank you Henric!