topic Re: How to convert varchar to float ? in QlikView

How to convert varchar to float ?

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

Hello All,

I have a column Risk_Contingency which is varchar. How can I convert this into float, I am also replacing the ',' with ' '.

Below is my SQL query for this

Convert(float, replace([Risk_Contingency_WBS], ',','')) as Risk_Contingency,

any help is greatly apprecaiated,

thanks

Bhavesh

vishsaggi — Mon, 27 Aug 2018 17:58:16 GMT

So what is the issue with your convert function? Is it not converting to float?

bhaveshp90 — Mon, 27 Aug 2018 19:02:56 GMT

It is converting to float in SQL, but I am trying to write the same logic in QlikView (in my expression)

trdandamudi — Mon, 27 Aug 2018 19:09:21 GMT

See if the below link helps...

vishsaggi — Mon, 27 Aug 2018 19:12:59 GMT

May be use Num() function like

Num(Trim(replace([Risk_Contingency_WBS], ',','')), '#,##0.00')

What are the values in your RiskContingency field?