topic Re: How to convert string to number? in QlikView

How to convert string to number?

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table as shown below; When selected Code = 17 the value is showing as 0

For Code = 17, the value is a string which is why my expression is not working.

Sum(Num#(Forecast_Cost_to_Complete,'###,###,###'))

Any ideas how to resolve this?

thanks

Gysbert_Wassenaar — Fri, 09 Nov 2018 18:43:36 GMT

Try adding a format for the negative numbers into the format string: =num#('(1234,12)', '#,##0.00;(#,##0.00)' , ',' , '.' )

sujana1621 — Fri, 09 Nov 2018 19:07:22 GMT

Try this sum(num#(replace(replace(Forecast_Cost_to_Complete,'(',''),')',''),'####')

bhaveshp90 — Fri, 09 Nov 2018 19:18:26 GMT

thank you gwassenaar‌. It worked out. slight change I have removed '.' and is working well.

=Num(Sum(Num#(Forecast_Cost_to_Complete,'###,###,###;(###,###,###)' , ',')),'###,###,###,###')

aolaleye — Wed, 06 Nov 2019 18:07:40 GMT

Thanks for sharing this tip. 😁It solved my problem and all my numbers showed on the report. It seems they were initially stored as strings