Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with converting text to number

Hi

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

RendimientoObjetivonum.PNG

the other ones, they dosnt seem to convert,

presentacion.PNG

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!

1 Solution

Accepted Solutions
mkelemen
Creator III
Creator III

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

View solution in original post

14 Replies
vishsaggi
Champion III
Champion III

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?

Not applicable
Author

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

list.PNG

vishsaggi
Champion III
Champion III

can you share a sample with just that field ?

vishsaggi
Champion III
Champion III

Can you try this in your Load script

Num(Yourfieldname, '0.0') AS yourfieldname;

Not applicable
Author

it only discards the other numbers

puronum.PNG

vishsaggi
Champion III
Champion III

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?

Not applicable
Author

It does not change anything..

I am preparing the app for you.

MK_QSL
MVP
MVP

Try

Num(YourNumberField) as NumberField

Not applicable
Author

As i said before, done that,

it only discards the other numbers

puronum.PNG