topic Re: Expression in qlikview in QlikView

Expression in qlikview

capriconuser — Sat, 16 Nov 2024 02:46:54 GMT

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

Re: Expression in qlikview

m_woolf — Fri, 09 Aug 2019 11:53:59 GMT

If I'm reading your logic correctly, try:

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

Re: Expression in qlikview

capriconuser — Fri, 09 Aug 2019 12:06:57 GMT

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

Re: Expression in qlikview

m_woolf — Fri, 09 Aug 2019 12:10:58 GMT

Your logic says:

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

Shouldn't that also be "="

Re: Expression in qlikview

capriconuser — Fri, 09 Aug 2019 12:33:10 GMT

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

Re: Expression in qlikview

capriconuser — Fri, 09 Aug 2019 13:26:55 GMT

Kindly check update question

https://community.qlik.com/t5/QlikView-Creating-Analytics/Expression-according-to-multiple-conditions/m-p/1611150#M47417