Solved: Re: Problem with converting text to number - Qlik Community

Report Inappropriate Content · ‎2016-12-16

Hi

im trying to convert some text to number but it only converts two of my data

the other ones, they dosnt seem to convert,

and they are pure text, as you can see in the image, i have tried NUM() and NUM#() at load and at expression,

but it only converts the 3.6 and 3.8 but the others dosnt seem to work

Do anyone have an idea why is this not working?

Thanks!

mkelemen · ‎2016-12-19

Hi,

could there be a space in front of the numbers? Try using Trim().

It would help if you can post the source data for the numbers.

BR,

Matus

vishsaggi · ‎2016-12-16

Create a list box and see, if text then the numbers will be displayed on left, if it is number it will be displayed on Right? Am i right?

Report Inappropriate Content · ‎2016-12-16

thats right, as i was saying some of them are text and some of them are number... weird!

vishsaggi · ‎2016-12-16

can you share a sample with just that field ?

vishsaggi · ‎2016-12-16

Can you try this in your Load script

Num(Yourfieldname, '0.0') AS yourfieldname;

Report Inappropriate Content · ‎2016-12-16

it only discards the other numbers

vishsaggi · ‎2016-12-16

in the list box properties number tab can you change that to numeric and see? If not can you share a sample app to look into?

Report Inappropriate Content · ‎2016-12-16

It does not change anything..

I am preparing the app for you.

MK_QSL · ‎2016-12-17

Try

Num(YourNumberField) as NumberField

Report Inappropriate Content · ‎2016-12-19

As i said before, done that,

it only discards the other numbers