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

How to convert this SQL statement in my script?

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

Hello,

I have this SQL case statement for summing up the values after converting as shown below;

CASE WHEN NCC.ncc_type='-' THEN

SUM

(

CASE WHEN NCC.[NCC_ve_NCC] IS NULL THEN ''

WHEN NCC.[NCC_ve_NCC] LIKE '%.''%' THEN CAST(REPLACE(LTRIM(RTRIM(NCC.[NCC_ve_NCC])),'.''','.') AS FLOAT)

ELSE CAST(REPLACE(REPLACE(LTRIM(RTRIM(NCC.[NCC_ve_NCC])),',',''),',','') AS FLOAT)

END

)

ELSE 0

END AS 'Overrun_Cost',

How can I include in my script? Any help is appreciated.

thanks

Bhavesh

jyothish8807 — Wed, 12 Sep 2018 05:24:12 GMT

Try this once:

=if(NCC.ncc_type = '-',

if(isnull( NCC.[NCC_ve_NCC]),'',

if(wildmatch(NCC.[NCC_ve_NCC],'%.''%'), num(replace(trim(NCC.[NCC_ve_NCC]),'.''','.')),

REPLACE(REPLACE(TRIM(NCC.[NCC_ve_NCC]),',',''),',','')

)),0)

as Overrun_Cost

resident <>;

Need to check the brackets.

Br,

bhaveshp90 — Thu, 04 Oct 2018 14:59:23 GMT

thank you it worked