topic Problem with converting text to number in QlikView

Problem with converting text to number

Fri, 16 Dec 2016 22:37:34 GMT

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!

Re: Problem with converting text to number

vishsaggi — Fri, 16 Dec 2016 22:41:34 GMT

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?

Re: Problem with converting text to number

Fri, 16 Dec 2016 22:45:05 GMT

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

Re: Problem with converting text to number

vishsaggi — Fri, 16 Dec 2016 22:55:41 GMT

can you share a sample with just that field ?

Re: Problem with converting text to number

vishsaggi — Fri, 16 Dec 2016 23:34:07 GMT

Can you try this in your Load script

Num(Yourfieldname, '0.0') AS yourfieldname;

Re: Problem with converting text to number

Fri, 16 Dec 2016 23:41:46 GMT

it only discards the other numbers

Re: Problem with converting text to number

vishsaggi — Sat, 17 Dec 2016 00:32:32 GMT

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?

Re: Problem with converting text to number

Sat, 17 Dec 2016 00:40:59 GMT

It does not change anything..

I am preparing the app for you.

Re: Problem with converting text to number

MK_QSL — Sat, 17 Dec 2016 11:01:35 GMT

Try

Num(YourNumberField) as NumberField

Re: Problem with converting text to number

Mon, 19 Dec 2016 15:43:53 GMT

As i said before, done that,

it only discards the other numbers

Re: Problem with converting text to number

dmitrydv — Mon, 19 Dec 2016 15:57:22 GMT

‌Could you export your data into XLS?

Re: Problem with converting text to number

vishsaggi — Mon, 19 Dec 2016 16:10:23 GMT

would it be possible to share an app ?

Re: Problem with converting text to number

mkelemen — Mon, 19 Dec 2016 16:12:26 GMT

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

Re: Problem with converting text to number

Mon, 19 Dec 2016 16:24:36 GMT

Thank you very much, i think it was a space.

Trim did the trick.

Re: Problem with converting text to number

tsponagel — Thu, 23 Jul 2020 08:55:39 GMT

Thanks, the TRIM-Statement was the solution.