topic Re: Currency Conversion NOT on day basys in QlikView https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965693#M331015 <HTML><HEAD></HEAD><BODY><P>If I understand, I think you should add all the missing dates</P><P>There is an example (and the script too) here</P><P><A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A></P></BODY></HTML> Mon, 23 Nov 2015 19:06:19 GMT maxgro 2015-11-23T19:06:19Z Currency Conversion NOT on day basys https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965692#M331014 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I read posts as this one: <A href="https://community.qlik.com/thread/14809">Currency Conversion</A></P><P>But my problem goes a step further. My conversion table is not created on a day by day conversion basys. I have the exchange rate of some days only (let's say once a week for example), and what I need to do is to convert my billing amount using the exchange rate of the first date before my billing date.</P><P>Can somehow the standard Currency Conversion be adapted into this? Has anyone faced something like this?</P><P></P><P>Thanks!!</P></BODY></HTML> Mon, 23 Nov 2015 17:36:44 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965692#M331014 m_baroja 2015-11-23T17:36:44Z Re: Currency Conversion NOT on day basys https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965693#M331015 <HTML><HEAD></HEAD><BODY><P>If I understand, I think you should add all the missing dates</P><P>There is an example (and the script too) here</P><P><A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A></P></BODY></HTML> Mon, 23 Nov 2015 19:06:19 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965693#M331015 maxgro 2015-11-23T19:06:19Z Re: Currency Conversion NOT on day basys https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965694#M331016 <HTML><HEAD></HEAD><BODY><P>You understood perfectly and that's what I needed!</P><P>Thanks maxgro!</P></BODY></HTML> Mon, 23 Nov 2015 20:01:49 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion-NOT-on-day-basys/m-p/965694#M331016 m_baroja 2015-11-23T20:01:49Z