Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

sagarrahul
New Contributor III

compare 2 dif rows

hii friends

need a help from you

this is my table     

ENGINE_NUMDATE_OF_LOSSSTART_DATEPOL_NUM
/1715612-Nov-201412-Oct-20142312200877894561
/1715616-Aug-201123-Jul-20112312200107165498

i table both of my ENGINE_NUM are same

but its policy num are different of /17156

and we have to compare  DATE_OF_LOSS with start date if ENGINE_NUM  are same as shown in above table 

16-Aug-2011 is small than 12-Oct-2014

if it satisfy then it should give its policy_num with its start date

so output sholud be :

ENGINE_NUMDATE_OF_LOSSSTART_DATEPOL_NUM
/1715612-Nov-201412-Oct-20142312200877894561
Community Browser