topic Re: Script Creation in QlikView https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566126#M685972 <HTML><HEAD></HEAD><BODY><P>If( IsNull( Ratio ), Peek( Ratio ), Ratio ) as Ratio</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Fri, 24 Jan 2014 18:03:25 GMT Anonymous 2014-01-24T18:03:25Z Script Creation https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566124#M685970 <HTML><HEAD></HEAD><BODY><P>Hey I have a file that has conversion ratios up to a certain date. But I am joining these on to another table with just a date range that matches the invoice dates. </P><P></P><P>I would like to have all the dates past my conversion ratio to be the last conversion made rather than null. I've attached a test example.</P><P></P><P>Thanks,</P><P>Kevin</P></BODY></HTML> Fri, 24 Jan 2014 15:50:07 GMT https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566124#M685970 2014-01-24T15:50:07Z Re: Script Creation https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566125#M685971 <HTML><HEAD></HEAD><BODY><P>Hey Kevin,</P><P>I would do something like this. I created a dummy table with data similar to what you explained. So for dates that don't have a conversion factor the last available date's conversion factor should be copied over to the rest of the dates(If i understood correctly).</P><P></P><P>Hope it helps</P><P>Thanks</P><P>AJ</P></BODY></HTML> Fri, 24 Jan 2014 17:39:35 GMT https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566125#M685971 2014-01-24T17:39:35Z Re: Script Creation https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566126#M685972 <HTML><HEAD></HEAD><BODY><P>If( IsNull( Ratio ), Peek( Ratio ), Ratio ) as Ratio</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Fri, 24 Jan 2014 18:03:25 GMT https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566126#M685972 Anonymous 2014-01-24T18:03:25Z Re: Script Creation https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566127#M685973 <HTML><HEAD></HEAD><BODY><P>This is what I ended up figuring outl. Thanks!!</P></BODY></HTML> Fri, 24 Jan 2014 18:06:44 GMT https://community.qlik.com/t5/QlikView/Script-Creation/m-p/566127#M685973 2014-01-24T18:06:44Z