Passing Particular Data value

krishna20 — Mon, 18 Aug 2014 06:59:49 GMT

Hi Friends,

how to pass a particular date value in expression.

i need to pass every year last date.i.e; 31Dec2013, 31Dec2012 where i used today() in the below expression.

=(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_TRANS_ID={"=CLM_TRANS_ID=CE_CLM_TRANS_ID"},CS_CLM_TRANS_ID={"=CS_CLM_TRANS_ID=CE_CLM_TRANS_ID"},CE_EST_SR_NO={"CE_EST_SR_NO=CS_EST_SR_NO"},CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"},CE_EST_SR_NO={"=len(trim(CE_EST_SR_NO))>0"},CS_PARTY_ID={"=len(trim(CS_PARTY_ID))>0"},CE_PARTY_ID={"=len(trim(CE_PARTY_ID))>0"}>}CS_AMT_LC_1)

(sum({<CS_EST_TYPE={"=CS_EST_TYPE=3"},CE_DT={"=CE_DT<=Today()"},CE_PARTY_ID={"=CE_PARTY_ID=CS_PARTY_ID"},CLM_TRANS_ID={"=CLM_TRANS_ID=CE_CLM_TRANS_ID"},CS_CLM_TRANS_ID={"=CS_CLM_TRANS_ID=CE_CLM_TRANS_ID"},CE_EST_SR_NO={"CE_EST_SR_NO=CS_EST_SR_NO"},CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"},CE_EST_SR_NO={"=len(trim(CE_EST_SR_NO))>0"},CS_PARTY_ID={"=len(trim(CS_PARTY_ID))>0"},CE_PARTY_ID={"=len(trim(CE_PARTY_ID))>0"}>}CS_AMT_LC_1)))))

please anyone suggest me how to resolve this issue

Thanks & Regards

Krishna

Re: Passing Particular Data value

ashfaq_haseeb — Mon, 18 Aug 2014 07:41:36 GMT

Hi,

Replace today() with YearEnd(today())

Make sure to format date as required.

Regards

ASHFAQ

topic Passing Particular Data value in QlikView

Passing Particular Data value

Re: Passing Particular Data value