topic Re: How to convert this SQL in to my script? in QlikView

How to convert this SQL in to my script?

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

Hello,

I have the below SQL statement;

CONVERT(DECIMAL(5,2),convert(float, replace(proj.[POC], '%',''))/100) [Current POC],

How to include this in my script to load the data?

thanks

Bhavesh

vishsaggi — Tue, 11 Sep 2018 15:39:17 GMT

May be this? If this does not work can you share some sample data with your expected output.

Num(Replace(proj.[POC], '%','')/100, '#,###0.00') AS [Current POC]

bhaveshp90 — Tue, 11 Sep 2018 16:29:03 GMT

This is my Data looks like :

When I add your code in the script = Num(Replace(proj.[POC], '%','')/100, '#,###0.00') AS [Current POC]

this is my result :

My Expected result should be: 96.70 %, 1.30%, 81.50%

vishsaggi — Tue, 11 Sep 2018 17:57:58 GMT

Try this?

Num(Replace(POC, '%','')/100, '###0.00')&'%'