topic Re: Rate updation using effcetive from date and effective to date in QlikView https://community.qlik.com/t5/QlikView/Rate-updation-using-effcetive-from-date-and-effective-to-date/m-p/522515#M195229 <HTML><HEAD></HEAD><BODY><P>The following blog posts describe this problem:</P><P><A class="" href="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field</A></P><P><A class="" href="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates</A></P><P></P><P>HIC</P></BODY></HTML> Fri, 23 Aug 2013 06:18:55 GMT hic 2013-08-23T06:18:55Z Rate updation using effcetive from date and effective to date https://community.qlik.com/t5/QlikView/Rate-updation-using-effcetive-from-date-and-effective-to-date/m-p/522514#M195228 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have data in qvd which i copied in excel and qvw , My requirement is to create a master</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">prod Code</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">nbr</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>eff from</STRONG></TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>eff to date<BR /></STRONG></TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NBR</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">batch no</TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Both tables having data based on effictive from&nbsp; &amp; effective to&nbsp; date , I want to use peek function and <STRONG>batch no i want to get in master </STRONG> How to get this.</P><P></P><P>Thanks in adv</P><P></P><P>Vikas</P></BODY></HTML> Fri, 23 Aug 2013 05:11:22 GMT https://community.qlik.com/t5/QlikView/Rate-updation-using-effcetive-from-date-and-effective-to-date/m-p/522514#M195228 vikasmahajan 2013-08-23T05:11:22Z Re: Rate updation using effcetive from date and effective to date https://community.qlik.com/t5/QlikView/Rate-updation-using-effcetive-from-date-and-effective-to-date/m-p/522515#M195229 <HTML><HEAD></HEAD><BODY><P>The following blog posts describe this problem:</P><P><A class="" href="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field</A></P><P><A class="" href="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates</A></P><P></P><P>HIC</P></BODY></HTML> Fri, 23 Aug 2013 06:18:55 GMT https://community.qlik.com/t5/QlikView/Rate-updation-using-effcetive-from-date-and-effective-to-date/m-p/522515#M195229 hic 2013-08-23T06:18:55Z