topic Re: Convert Text to Number in QlikView

Convert Text to Number

fkeuroglian — Thu, 09 Jan 2014 13:33:14 GMT

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

Re: Convert Text to Number

swuehl — Thu, 09 Jan 2014 15:02:37 GMT

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,'###,###',',','.'))

Re: Convert Text to Number

fkeuroglian — Fri, 10 Jan 2014 15:06:13 GMT

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

Re: Convert Text to Number

swuehl — Fri, 10 Jan 2014 16:22:40 GMT

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,'###,###;###,###-',',','.'))

Re: Convert Text to Number

achitreskyitgroup — Wed, 05 Dec 2018 16:05:49 GMT

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.

Re: Convert Text to Number

Valerie — Wed, 28 Aug 2019 03:08:39 GMT

Thanks this really solved my problem too.

Re: Convert Text to Number

PuriVelasco — Wed, 28 Jul 2021 13:09:38 GMT

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.