Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Contributor III
Contributor III

status according to dates in qlikview expression

hi i have several records like this

 _number oldpolicy   from date   to date   status

   213      -        01/01/2018   12/31/2018   lost

the status is lost beacuse there is no oldpolicy number and also to date is passed so these kind of records should be lost

_number oldpolicy   from date   to date     status

   1234      1d23    01/01/2018   04/31/2019   lost

these kind of records also lost beacuse oldpolicy is there but to date is passed and this "_number" did not renew again so these kind of records also lost

_number oldpolicy   from date   to date     status

   abc    abc134      01/01/2018   05/31/2019   renew
   324     abc        05/31/2019   12/31/2019    renew

in this abc policy is renewed with new _number record and to date is still not pass so these kind of records is renew

_number oldpolicy   from date   to date     status

   324    -             02/31/2019   12/31/2019    new

in this records who are in current year and old policy is also empty and to date is not pass so these kind records are new ..

so how i modified this expression according to above expressions

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

in this i use UW_Year but now i want to modified according from date and to date .. how i modified ..

Labels (2)
0 Replies