https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701524#M451223 <P>From your data model, it seems that you need only the sales based on the current currency rates. If so, I believe that you don't need to link the Currency table with the rest of the data model. So try to simply drop the field SupplierID.</P> Wed, 13 May 2020 11:55:54 GMT fosuzuki 2020-05-13T11:55:54Z https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701038#M451194 <P>Hi, can anyone help me how to select the currency and display it to the table repeatedly. Then it will multiply the total sales and currency rates of each country.</P><P>For example see picture below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 314px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33424i613683CF1221105E/image-size/medium?v=v2&amp;px=400" role="button" title="2.PNG" alt="2.PNG" /></span></P><P>But my problem looks like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5.PNG" style="width: 546px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33427i2F361A25059176C6/image-size/medium?v=v2&amp;px=400" role="button" title="5.PNG" alt="5.PNG" /></span></P><P> thank you. Hope anyone can help.&nbsp;</P> Tue, 12 May 2020 10:39:34 GMT https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701038#M451194 mdvelasco 2020-05-12T10:39:34Z https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701435#M451211 <P>Hi,</P><P>can you share your data model?</P> Wed, 13 May 2020 08:54:54 GMT https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701435#M451211 fosuzuki 2020-05-13T08:54:54Z https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701464#M451214 <P>Hi Fosuzuki,</P><P>Here's my data model. Thank you for your response.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.PNG" style="width: 833px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33509i5B33F40E6DC296D3/image-size/medium?v=v2&amp;px=400" role="button" title="1.PNG" alt="1.PNG" /></span></P><P> </P> Wed, 13 May 2020 09:47:30 GMT https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701464#M451214 mdvelasco 2020-05-13T09:47:30Z https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701524#M451223 <P>From your data model, it seems that you need only the sales based on the current currency rates. If so, I believe that you don't need to link the Currency table with the rest of the data model. So try to simply drop the field SupplierID.</P> Wed, 13 May 2020 11:55:54 GMT https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701524#M451223 fosuzuki 2020-05-13T11:55:54Z https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701533#M451224 <P>Wow it works! Thank you very much <span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span>&nbsp;</P> Wed, 13 May 2020 12:15:48 GMT https://community.qlik.com/t5/QlikView/Selection-of-currency-with-conversion-of-exchange-rate/m-p/1701533#M451224 mdvelasco 2020-05-13T12:15:48Z