Expression in qlikview

[capriconuser]

This is the expression what i have

 if(Len([Parent Policy])=0 and UW_YEAR<Year(Today()) , 'new',
if(UW_YEAR<Year(Today()) and Len([Parent Policy])>0 , 'lost', 'renew')
)

but this expression did not working

data is like

Child policy parent policy Year   Status
12                -         2018   Lost

this means that this child policy not exist in current year (2019) and also dont have parent policy (parent policy means this policy not coming from previous year like 2017, 2016 etc ) so this should be lost

if this policy coming from previous year and parent policy is exist then status is renew but if this policy not exist in current year then last record should be lost

Child policy parent policy   Year   Status
12                456         2017   renew
124              12           2018   lost

and other condition is when policy exist in current year then those all policies should be new

Child policy parent policy   Year     Status
12                456         2017     renew
124              12           2018     lost
abc-12          -             2019      new
anx-1345        -             2019      new 

so how i modify expression according to these conditions

[m_woolf]

If I'm reading your logic correctly, try:

if(Len([Parent Policy])=0 and UW_YEAR=Year(Today()) , 'new',

[capriconuser]

oh sorry this is by mistake in question it is already  ' = ' sign.

and when i try this expression 

then data is like this where as that kind of record should be lost.. because there is no parent policy 

Child policy    parent policy          year             Status

123xc                  -                             2018               renew

so data should be like this 

Child policy    parent policy          year             Status

123xc                  -                             2018               lost

[m_woolf]

Your logic says:

if(UW_YEAR<Year(Today()) and Len([Parent Policy])>0 , 'lost', 'renew')

Shouldn't that also be "=" 

[capriconuser]

now i have a different question so how i delete this question because now this not relevant to issue

[capriconuser]

Kindly check update question 

https://community.qlik.com/t5/QlikView-Creating-Analytics/Expression-according-to-multiple-condition...