Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
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
Num#(Totale,'0.0') as Totale,
You can try like num(field) as field_name
Num(String_field) as No_Field
Num() handles negative values also.
Check it whether you have null values in your field.
You should use like this
Num(Field) as Number
Hope it helps
You can Num() or Num#() to format String to Number.
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