topic Re: issue in QlikView https://community.qlik.com/t5/QlikView/issue/m-p/1341824#M413255 <HTML><HEAD></HEAD><BODY><P>'tested data of max date' (assuming max date 10/06/2017) is 'scheduled'.</P><P>Why in Your field output is 'Pass' ?</P></BODY></HTML> Fri, 09 Jun 2017 08:08:07 GMT antoniotiman 2017-06-09T08:08:07Z issue https://community.qlik.com/t5/QlikView/issue/m-p/1341823#M413254 <HTML><HEAD></HEAD><BODY><P>hi eveyone</P><P>needs to one more fields which include tested data of max date</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166317_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/166318_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 09 Jun 2017 08:02:22 GMT https://community.qlik.com/t5/QlikView/issue/m-p/1341823#M413254 Anonymous 2017-06-09T08:02:22Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/1341824#M413255 <HTML><HEAD></HEAD><BODY><P>'tested data of max date' (assuming max date 10/06/2017) is 'scheduled'.</P><P>Why in Your field output is 'Pass' ?</P></BODY></HTML> Fri, 09 Jun 2017 08:08:07 GMT https://community.qlik.com/t5/QlikView/issue/m-p/1341824#M413255 antoniotiman 2017-06-09T08:08:07Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/1341825#M413256 <HTML><HEAD></HEAD><BODY><P>Shweta,</P><P>Please come in clear words that what you need.</P></BODY></HTML> Fri, 09 Jun 2017 08:24:16 GMT https://community.qlik.com/t5/QlikView/issue/m-p/1341825#M413256 sujeetsingh 2017-06-09T08:24:16Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/1341826#M413257 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>1 example:</P><P>LOAD *, if(len(Previous(Tested))=0,Tested,Previous(Tested)) AS Tested_ll;</P><P>LOAD * Inline [</P><P>GEL ID,Contigency Date,Tested</P><P>10360,21/02/2015,Pass</P><P>10360,21/05/2016,Pass</P><P>10360,10/06/2017,Scheduled</P><P>] ;</P><P>EXIT Script;</P></BODY></HTML> Fri, 09 Jun 2017 15:37:51 GMT https://community.qlik.com/t5/QlikView/issue/m-p/1341826#M413257 el_aprendiz111 2017-06-09T15:37:51Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/1341827#M413258 <HTML><HEAD></HEAD><BODY><P>can we achieve the same by front end</P></BODY></HTML> Wed, 14 Jun 2017 04:23:34 GMT https://community.qlik.com/t5/QlikView/issue/m-p/1341827#M413258 Anonymous 2017-06-14T04:23:34Z