topic Re: How convert string to number for sum() in QlikView

How convert string to number for sum()

Mon, 24 Aug 2015 15:42:44 GMT

Hi every body! I

I need your help for this issue..

I got the field "COSTO_TOTAL_OBRA.RPM_ITEM_D" with the values 20 and 29.670,00 but when I do the sum(): sum(COSTO_TOTAL_OBRA.RPM_ITEM_D) the result is: 20 (Object text in the image)

I think that the trouble is that "29.670,00" its a string in place of number, but I don't know how convert this string to number and that then the app shows me the correct result (29.690,00)

I attach the script!

Thanks in advance!

Agus

Re: How convert string to number for sum()

kaushiknsolanki — Mon, 24 Aug 2015 16:00:03 GMT

Try this,

=num(Num#(COSTO_TOTAL_OBRA.RPM_ITEM_D,'#.###,##',',','.'))

Regards,

Kaushik Solanki

Re: How convert string to number for sum()

Mon, 24 Aug 2015 17:55:08 GMT

Thanks a lot Kaushik !

Re: How convert string to number for sum()

Thu, 11 Aug 2016 18:37:23 GMT

Hi, i supose that your problem is in the separators.

See that you amount is the point (.) and the decimal separator is comma (",").

See example below:

Sumatoria:

LOAD sum(Codigos) as Codigos

FROM

(ooxml, embedded labels, table is Sheet1);