Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone tell me tat how can we write conditional and else statements in a single expression using set analysis.
Regards
krishna
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()))
Hi Sunil,
I have to check mainly CE_CLOSE_DT<Today() and CE_CLOSE_DT > Today() with the condition CE_CLOSE_YN='1'
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
hi have you checked the both date formats
CE_CLOSE_DT date format
if yes then post your sample file
Hi Sasi.
Pls Find the below attachment .
Regards
Krishna
post only your file .qvw
that zip file not able to open
Hi Sasi
Please find the attachment.
Regards
Krishna
Hi Sasi !
Did u got any way for that?
Regards
Krishna
no yaar i am not able to open that file also , it is giving me error load failed
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