Expression in Load script

krishna20 — Thu, 21 Aug 2014 10:23:44 GMT

Hi friends,

How can i write an expression in load script.

i have used an expression using SET ANALYSIS in front end.Due to performance lag i need to change my expression to load script.

My Expression is

(if((CLM_STATUS <>'C' or (CLM_STATUS='C' and Today()<=CLM_CLOSE_DT))and CLM_STATUS<>'R' and (CE_CLOSE_YN <> '1' or (CE_CLOSE_YN= '1' and CE_CLOSE_DT>Today())),

(sum({<CS_EST_TYPE={"=CS_EST_TYPE=1"},CE_DT={"=CE_DT<=Today()"},

CE_PARTY_ID={"=CE_PARTY_ID=CS_PARTY_ID"},CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"}>}AMOUNT)

here i'm comparing the fields from three tables A, B, C.

how can i keep resident for one and another table.

Please anyone suggest me how to do it so..

Thanks and Regards,

Krishna

topic Expression in Load script in QlikView

Expression in Load script