topic String to number conversion in QlikView

String to number conversion

Fri, 17 Feb 2012 09:02:48 GMT

Hello to everybody,

how can I convert ( in LOAD SCRIPT) the string 123456.34 to number 123456.34?

And for negative value string -123456.34 to number -123456.34

I have tried the instruction Num( ) but I cannot understand the syntax to manage the negative value

Regards

Oronzo

String to number conversion

Fri, 17 Feb 2012 09:10:24 GMT

Hi,

You can try like num(field) as field_name

Ex:

Num(String_field) as No_Field

-Jai

String to number conversion

CELAMBARASAN — Fri, 17 Feb 2012 09:16:30 GMT

Hi,

Num() handles negative values also.

Check it whether you have null values in your field.

You should use like this

Load

Fields,

Num(Field) as Number

From..

Hope it helps

Celambarasan

String to number conversion

jagan — Fri, 17 Feb 2012 09:19:12 GMT

Hi,

You can Num() or Num#() to format String to Number.

Regards,

Jagan.

String to number conversion

Fri, 17 Feb 2012 11:00:27 GMT

Hello

i have tried Num() and Num#() but for negative value, the string remains string and I cannot display on a chart

this is my load script

LOAD

Num#(Totale,'0.0') as Totale,

...........................

FROM

.....

Regards

Oronzo

String to number conversion

Fri, 17 Feb 2012 11:42:58 GMT

Thanks to everybody,

it was simply a problem with format number

if I use in the load SCRIPT

Num#(Totale,'0.00') as Totale,

it works fine

Regards

oronzo