Script

rathnam_qv — Tue, 20 Aug 2013 12:03:40 GMT

Hi all,

i hv writen the following script in the editor...

can any one help is it correct or not

CHAS_EXTRACT_2013:

LOAD RAM_HMDA_PURPOSE,
RAM_GEO_STATE,
RAM_GEO_COUNTY,
RAM_GEO_CENSUS_TRACT,
RAM_ACTION_TYPE,
RAM_HMDA_TYPE,
RAM_ACTION_DATE_YMD,
RAM_ACTION_DATE_CY,
BORROWER_SEG,
count(if(RAM_GEO_INC_SEG='L',1,0))as [Low Tract],
count(if(RAM_GEO_INC_SEG='M',1,0))as [Moderate Tract],
if(RAM_GEO_INC_SEG='L',sum(RAM_LOAN_AMT),0) as [Low Income],
if(RAM_GEO_BORROWER_INC_SEG='M' and BORROWER_SEG ='M',sum(RAM_LOAN_AMT),0) as [Moderate Income],
RAM_LOAN_AMT

Thanks in advance!!!

Smiley

Re: Script

m_woolf — Tue, 20 Aug 2013 15:07:16 GMT

You can't use aggregation functions in script without using GroupBy

Re: Script

rathnam_qv — Tue, 20 Aug 2013 15:57:08 GMT

Hi Michael,

can u send me the script please

topic Re: Script in QlikView

Script

Re: Script

Re: Script