topic Re: INSURANCE in QlikView https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041879#M350560 <HTML><HEAD></HEAD><BODY><P>Sorry I have marked other reply as correct by an error. Your reply matches my requirement but in my QV there are some other fields as well and I bit puzzled to to get connected to QV. I m attaching it Can you pls have look at it and advise</P></BODY></HTML> Tue, 22 Mar 2016 09:24:45 GMT upaliwije 2016-03-22T09:24:45Z INSURANCE https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041875#M350556 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been able to able to get output report from the data given in my attached QV document</P><TABLE><TBODY><TR><TD>POLICY_NO</TD><TD>YEAR</TD><TD>PERIOD_FROM</TD><TD>PERIOD_TO</TD><TD>Remarks</TD></TR><TR><TD>NI00111C000039</TD><TD>2012</TD><TD>10-Feb-2012</TD><TD>09-Feb-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00111C000039</TD><TD>2013</TD><TD>10-Feb-2013</TD><TD>09-Feb-2014</TD><TD>2ND YEAR</TD></TR><TR><TD>NI00111C000039</TD><TD>2014</TD><TD>10-Feb-2014</TD><TD>09-Feb-2015</TD><TD>NOT RENEWED</TD></TR><TR><TD>NI00111D000019</TD><TD>2012</TD><TD>31-May-2012</TD><TD>30-May-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00111D000019</TD><TD>2013</TD><TD>31-May-2013</TD><TD>30-May-2014</TD><TD>NOT RENEWED</TD></TR><TR><TD>NI00121C000069</TD><TD>2012</TD><TD>22-Jun-2012</TD><TD>21-Jun-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00121C000069</TD><TD>2013</TD><TD>22-Jun-2013</TD><TD>21-Jun-2014</TD><TD>2ND YEAR</TD></TR><TR><TD>NI00121C000069</TD><TD>2014</TD><TD>22-Jun-2014</TD><TD>21-Jun-2015</TD><TD>3RD YEAR</TD></TR><TR><TD>NI00121C000069</TD><TD>2015</TD><TD>22-Jun-2015</TD><TD>21-Jun-2016</TD><TD>LAST YEAR</TD></TR><TR><TD>NI00121D000053</TD><TD>2012</TD><TD>23-May-2012</TD><TD>22-May-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00121D000053</TD><TD>2013</TD><TD>23-May-2013</TD><TD>22-May-2014</TD><TD>NOT RENEWED</TD></TR><TR><TD>NI00121F000014</TD><TD>2012</TD><TD>06-Mar-2012</TD><TD>05-Mar-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00121F000014</TD><TD>2013</TD><TD>06-Mar-2013</TD><TD>05-Mar-2014</TD><TD>2ND YEAR</TD></TR><TR><TD>NI00121F000014</TD><TD>2014</TD><TD>06-Mar-2014</TD><TD>05-Mar-2015</TD><TD>3RD YEAR</TD></TR><TR><TD>NI00121F000014</TD><TD>2015</TD><TD>06-Mar-2015</TD><TD>05-Mar-2016</TD><TD>LAST YEAR</TD></TR><TR><TD>NI00131A000028</TD><TD>2013</TD><TD>13-May-2013</TD><TD>12-May-2014</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00131A000028</TD><TD>2014</TD><TD>13-May-2014</TD><TD>12-May-2015</TD><TD>NOT RENEWED</TD></TR><TR><TD>NI00141A0000041</TD><TD>2014</TD><TD>06-Oct-2014</TD><TD>05-Oct-2015</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00141A0000041</TD><TD>2015</TD><TD>06-Oct-2015</TD><TD>05-Oct-2016</TD><TD>LAST YEAR</TD></TR><TR><TD>NI00141C0000106</TD><TD>2014</TD><TD>13-Oct-2014</TD><TD>12-Oct-2015</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00141C0000106</TD><TD>2015</TD><TD>13-Oct-2015</TD><TD>12-Oct-2016</TD><TD>LAST YEAR</TD></TR><TR><TD>NI00141H0000032</TD><TD>2014</TD><TD>10-Nov-2014</TD><TD>09-Nov-2015</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00141H0000032</TD><TD>2015</TD><TD>10-Nov-2015</TD><TD>09-Nov-2016</TD><TD>LAST YEAR</TD></TR></TBODY></TABLE><P></P><P>But I need a modification to this output report as given below</P><P></P><TABLE><TBODY><TR><TD>POLICY_NO</TD><TD>YEAR</TD><TD>PERIOD_FROM</TD><TD>PERIOD_TO</TD><TD>Remarks</TD></TR><TR><TD>NI00111C000039</TD><TD>2012</TD><TD>10-Feb-2012</TD><TD>09-Feb-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00111C000039</TD><TD>2013</TD><TD>10-Feb-2013</TD><TD>09-Feb-2014</TD><TD>2ND YEAR</TD></TR><TR><TD>NI00111C000039</TD><TD>2014</TD><TD>10-Feb-2014</TD><TD>09-Feb-2015</TD><TD>3RD YEAR</TD></TR><TR><TD><STRONG>NI00111C000039</STRONG></TD><TD><STRONG>2015</STRONG></TD><TD><STRONG>10-Feb-2015</STRONG></TD><TD><STRONG>09-Feb-2016</STRONG></TD><TD><STRONG>NOT RENEWED</STRONG></TD></TR><TR><TD>NI00111D000019</TD><TD>2012</TD><TD>31-May-2012</TD><TD>30-May-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00111D000019</TD><TD>2013</TD><TD>31-May-2013</TD><TD>30-May-2014</TD><TD>2ND YEAR</TD></TR><TR><TD><STRONG>NI00111D000019</STRONG></TD><TD><STRONG>2014</STRONG></TD><TD><STRONG>31-May-2014</STRONG></TD><TD><STRONG>30-May-2015</STRONG></TD><TD><STRONG>NOT RENEWED</STRONG></TD></TR><TR><TD>NI00121C000069</TD><TD>2012</TD><TD>22-Jun-2012</TD><TD>21-Jun-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00121C000069</TD><TD>2013</TD><TD>22-Jun-2013</TD><TD>21-Jun-2014</TD><TD>2ND YEAR</TD></TR><TR><TD>NI00121C000069</TD><TD>2014</TD><TD>22-Jun-2014</TD><TD>21-Jun-2015</TD><TD>3RD YEAR</TD></TR><TR><TD>NI00121C000069</TD><TD>2015</TD><TD>22-Jun-2015</TD><TD>21-Jun-2016</TD><TD>LAST YEAR</TD></TR><TR><TD>NI00121D000053</TD><TD>2012</TD><TD>23-May-2012</TD><TD>22-May-2013</TD><TD>1ST YEAR</TD></TR><TR><TD>NI00121D000053</TD><TD>2013</TD><TD>23-May-2013</TD><TD>22-May-2014</TD><TD>2ND YEAR</TD></TR><TR><TD><STRONG>NI00121D000053</STRONG></TD><TD><STRONG>2014</STRONG></TD><TD><STRONG>23-May-2014</STRONG></TD><TD><STRONG>22-May-2015</STRONG></TD><TD><STRONG>NOT RENEWED</STRONG></TD></TR></TBODY></TABLE><P></P><P>In my requirement current not renewed records Remarks fields is replaced with next year eg 2ndYear, 3rd Year and&nbsp; new record is inserted with Remars NOT RENEWD and YEAR and PERIOD FROM AND PERIOD TO&nbsp; fields are advanced to corresponding Net year and next period . Newly added records are in bold letters.</P><P>Pls help me to fulfill this.</P></BODY></HTML> Tue, 22 Mar 2016 06:56:28 GMT https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041875#M350556 upaliwije 2016-03-22T06:56:28Z Re: INSURANCE https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041876#M350557 <HTML><HEAD></HEAD><BODY><P>Attached demo see if it can help you.</P><P></P><P>Vikas</P></BODY></HTML> Tue, 22 Mar 2016 07:30:03 GMT https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041876#M350557 vikasmahajan 2016-03-22T07:30:03Z Re: INSURANCE https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041877#M350558 <HTML><HEAD></HEAD><BODY><P>I have accidentally delete the reply Mr.Gysbert . Kindly attach the same please</P></BODY></HTML> Tue, 22 Mar 2016 08:16:59 GMT https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041877#M350558 upaliwije 2016-03-22T08:16:59Z Re: INSURANCE https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041878#M350559 <HTML><HEAD></HEAD><BODY><P>No you didn't delete it. I did. You marked Vikas answer as correct so I removed my post as it was not needed. Here's the example.</P></BODY></HTML> Tue, 22 Mar 2016 09:15:25 GMT https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041878#M350559 Gysbert_Wassenaar 2016-03-22T09:15:25Z Re: INSURANCE https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041879#M350560 <HTML><HEAD></HEAD><BODY><P>Sorry I have marked other reply as correct by an error. Your reply matches my requirement but in my QV there are some other fields as well and I bit puzzled to to get connected to QV. I m attaching it Can you pls have look at it and advise</P></BODY></HTML> Tue, 22 Mar 2016 09:24:45 GMT https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041879#M350560 upaliwije 2016-03-22T09:24:45Z Re: INSURANCE https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041880#M350561 <HTML><HEAD></HEAD><BODY><P>I'm afraid I don't understand your question. Can you explain in more detail what problems you have?</P></BODY></HTML> Tue, 22 Mar 2016 15:33:58 GMT https://community.qlik.com/t5/QlikView/INSURANCE/m-p/1041880#M350561 Gysbert_Wassenaar 2016-03-22T15:33:58Z