Set analysis with if else

[krishna20]

Hi,

Can anyone tell me tat how can we write conditional and else statements in a single expression using set analysis.

Regards

krishna

[SunilChauhan]

if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),0,if(CE_CLOSE_YN='1'andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))),

if(condition1 and condition2, Sum()))

[krishna20]

Hi Sunil,

I have to check mainly CE_CLOSE_DT<Today() and CE_CLOSE_DT > Today() with the condition CE_CLOSE_YN='1'

[SunilChauhan]

if(CE_CLOSE_YN='1'andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))),

if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),SUM(),0)

might be something like this you want

[sasikanth]

hi have you checked the both date formats

CE_CLOSE_DT date format

if yes then post your sample file

[krishna20]

Hi Sasi.

Pls Find the below attachment .

Regards

Krishna

[sasikanth]

post only your file .qvw

that zip file not able to open

[krishna20]

Hi Sasi

Please find the attachment.

Regards

Krishna

[krishna20]

Hi Sasi !

Did u got any way for that?

Regards

Krishna

[sasikanth]

no yaar i am not able to open that file also , it is giving me error load failed

[krishna20]

Hi sasi.

Can you provide your personal mail ID such that i can send the key for Qlikview.Apply it for your personal edition then you can able to open it.

Regards

Krishna