topic Re: script from DB2 Expression in QlikView

script from DB2 Expression

rathnam_qv — Sat, 24 Aug 2013 06:33:10 GMT

Hi all,

i have the following

sum((case when RAM_GEO_INC_SEG ='L'or RAM_GEO_INC_SEG ='M' then 1 else 0 end) +(case when coalesce(BORROWER_SEG,RAM_GEO_BORROWER_INC_SEG) ='L' or coalesce(BORROWER_SEG,RAM_GEO_BORROWER_INC_SEG) ='M'then 1 else 0 end) STB_CRA_CNT

can any send me Script for this please...it's urgent

Thnaks in advncae!!!!
Smiley

Re: script from DB2 Expression

rajeshvaswani77 — Sat, 24 Aug 2013 06:43:36 GMT

Hi Smiley,

Below should work.

sum(if((RAM_GEO_INC_SEG ='L'or RAM_GEO_INC_SEG ='M'),1,0))

thanks,

-RV

Re: script from DB2 Expression

rathnam_qv — Sat, 24 Aug 2013 07:11:49 GMT

Hi Rajesh,

Thanks for ur replay,

but i want script for all the sql which i have mentioned above

Re: script from DB2 Expression

rajeshvaswani77 — Sat, 24 Aug 2013 07:27:25 GMT

sum(if((RAM_GEO_INC_SEG ='L'or RAM_GEO_INC_SEG ='M'),1,0) + if(isnull(BORROWER_SEG),if(RAM_GEO_BORROWER_INC_SEG='L',1,0),if(BORROWER_SEG='L',1,0)) OR if(isnull(BORROWER_SEG),if(RAM_GEO_BORROWER_INC_SEG='M',1,0),if(BORROWER_SEG='M',1,0)))

Re: script from DB2 Expression

Gysbert_Wassenaar — Sat, 24 Aug 2013 11:59:36 GMT

To begin with if you have a working sql statement you can simply reuse that in Qlikview:

MyTable:

SELECT xxx from yyy ...etc;

This way you don't have to convert the sql to Qlikview script.

But if you really want or need to... try this:

sum(

if(match(RAM_GEO_INC_SEG,'L','M'),1,0) +

if(alt(match(BORROWER_SEG,'L','M'),match(RAM_GEO_BORROWER_INC_SEG,'L','M')),1,0)

) as STB_CRA_CNT