Convert Text to Number

[fkeuroglian]

I want to convert TEXT to NUMBER, but when i convert in the view table, do not say NUMBER FORMAT(not appear any format) and when I try to SUM() the convert field , the result is 0.

Please help, i attach the example .qvd

it have 2 object, one correct with the NUM# function(appears the value) and other with the sum() function that show 0(CERO)

if anybody can see, I apreciatte a lot !!!

Fernando

[swuehl · Accepted solution]

Your num#() function doesn't work properly, but unfortunately num#() will return the original string, if the parsing failed.

(check by using num(num#(FIELD, FORMAT)) to see if the parsing worked out).

This should work, using a different format code and separator definitions:

=Sum(Num#(TEST1,'###,###',',','.'))

[fkeuroglian]

Thank you SWUEHL!!

thats work ok! another question pherhaps you know, I have another problem, do not recognize negatives value, it seems that they not numbers

if you select a negative value, its return -

thank you a lot!!

Fernando

[swuehl]

A negative value has a trailing minus sign in your case? Then you need to add the format for your negative values in the format code:

=Sum(Num#(TEST1,'###,###;###,###-',',','.'))

[achitreskyitgroup]

I want to Convert text to Number. My data is as follows:

SALES_DOLLARS
6336,21
3991,81
19008,63
-4688,8
4435,34
6336,21
6336,21
4435,34
4435,34

I want to replace the ',' to a '.(Decimal)' and change the type from Text to Number.

Thank you.

[Valerie]

Thanks this really solved my problem too.

[PuriVelasco]

Good morning,

I have the same problem that  @fkeuroglian, but the solution doen't run for me.

I am in Qlik Sense.

I am using Sum(Num#(TEST1,'###,###',',','.')) in my field I obtain 0.

Thank you very much.