topic Re: Mapping Table in QlikView https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678751#M1071359 <HTML><HEAD></HEAD><BODY><P>it is the required way otherwise the model wont have accurate data</P></BODY></HTML> Thu, 14 Aug 2014 06:12:11 GMT 2014-08-14T06:12:11Z Mapping Table https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678748#M1071356 <HTML><HEAD></HEAD><BODY><P><BR />Hi All</P><P></P><P>I need to create a mapping table that will have fields: (Finincial Year, Exchnage Rate).</P><P>The finicial year is 01 July- 30June e.g (2013-07-01---&gt;2014-06-30). I need to add the Financial Year field to an existing table and have the Exchange Rate applied to the Finacial Year calendar and not the ordinary year calendar (Jan-Dec). How can I achieve this?</P></BODY></HTML> Thu, 14 Aug 2014 05:49:02 GMT https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678748#M1071356 2014-08-14T05:49:02Z Re: Mapping Table https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678749#M1071357 <HTML><HEAD></HEAD><BODY><P>See this: <A href="http://community.qlikview.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year" title="http://community.qlikview.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year">Qlik Design Blog : Fiscal Year | Qlik Community</A></P></BODY></HTML> Thu, 14 Aug 2014 05:55:05 GMT https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678749#M1071357 tresB 2014-08-14T05:55:05Z Re: Mapping Table https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678750#M1071358 <HTML><HEAD></HEAD><BODY><P>It is the best way to use Fiscal date concepts</P></BODY></HTML> Thu, 14 Aug 2014 06:03:45 GMT https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678750#M1071358 sujeetsingh 2014-08-14T06:03:45Z Re: Mapping Table https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678751#M1071359 <HTML><HEAD></HEAD><BODY><P>it is the required way otherwise the model wont have accurate data</P></BODY></HTML> Thu, 14 Aug 2014 06:12:11 GMT https://community.qlik.com/t5/QlikView/Mapping-Table/m-p/678751#M1071359 2014-08-14T06:12:11Z