topic Re: Generating dates and values from the last record in QlikView https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441097#M432397 <HTML><HEAD></HEAD><BODY><P>Also, look here:</P><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Tue, 22 Aug 2017 15:38:09 GMT sunny_talwar 2017-08-22T15:38:09Z Generating dates and values from the last record https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441095#M432395 <HTML><HEAD></HEAD><BODY><P>Hello, I am making a dashboard that contains some FX rates and documents so I linked the FX table to my data table via a key containing the date and base currency of the document. Problem is, I have the FX rates for the last working day. while some of my documents come in the weekend. This way I cannot access these documents.</P><P></P><P>The simplest solution that came in mind was to generate a date in the FX table a few days ahead with the same exchange rate as Friday(the last working day).</P><P></P><P>How can one do this in Qlikview?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 22 Aug 2017 08:04:21 GMT https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441095#M432395 2017-08-22T08:04:21Z Re: Generating dates and values from the last record https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441096#M432396 <HTML><HEAD></HEAD><BODY><P>I think the following thread could contain the solution you're looking for:</P><P><A href="https://community.qlik.com/thread/269666">Populate column with previous available value.</A></P></BODY></HTML> Tue, 22 Aug 2017 15:27:25 GMT https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441096#M432396 micheledenardi 2017-08-22T15:27:25Z Re: Generating dates and values from the last record https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441097#M432397 <HTML><HEAD></HEAD><BODY><P>Also, look here:</P><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Tue, 22 Aug 2017 15:38:09 GMT https://community.qlik.com/t5/QlikView/Generating-dates-and-values-from-the-last-record/m-p/1441097#M432397 sunny_talwar 2017-08-22T15:38:09Z