topic Re: Exchange rate in QlikView https://community.qlik.com/t5/QlikView/Exchange-rate/m-p/1178372#M902284 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>Sellout Table</P><P><STRONG>MonthName(Datum) as MonthYear</STRONG></P><P></P><P>Exchange Rate Table</P><P><STRONG>MonthName(Date#(Year &amp; '-' &amp; Month, 'YYYY-MMMM')) as MonthYear</STRONG></P></BODY></HTML> Tue, 05 Jul 2016 20:37:36 GMT sunny_talwar 2016-07-05T20:37:36Z Exchange rate https://community.qlik.com/t5/QlikView/Exchange-rate/m-p/1178371#M902283 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P>i need your help? How to make link between 2 tables/</P><P>1 of them is sell out and 2nd one is table with exchange rate</P><P></P><P>sell out:</P><P>column 1</P><P>column 2</P><P>Datum</P><P>.<IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130221_1.png" style="height: auto;" /><SPAN style="font-size: 10pt; line-height: 1.5em;">.</SPAN></P><P>exchange rate:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 294px;"><TBODY><TR><TD class="xl63" height="17" width="98">Year</TD><TD class="xl63" width="98">Month</TD><TD class="xl63" width="98">Echange rate</TD></TR><TR><TD class="xl63" height="17">2016</TD><TD class="xl63">June</TD><TD class="xl63">121,3</TD></TR></TBODY></TABLE><P></P><P></P><P>Can anyone help me little beat how to connect these two tables?</P><P></P><P>Please put picture, I use PE Qlik. </P><P>Thank you in advance, </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exchange-rate/m-p/1178371#M902283 qlikserbian 2020-11-25T16:16:04Z Re: Exchange rate https://community.qlik.com/t5/QlikView/Exchange-rate/m-p/1178372#M902284 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>Sellout Table</P><P><STRONG>MonthName(Datum) as MonthYear</STRONG></P><P></P><P>Exchange Rate Table</P><P><STRONG>MonthName(Date#(Year &amp; '-' &amp; Month, 'YYYY-MMMM')) as MonthYear</STRONG></P></BODY></HTML> Tue, 05 Jul 2016 20:37:36 GMT https://community.qlik.com/t5/QlikView/Exchange-rate/m-p/1178372#M902284 sunny_talwar 2016-07-05T20:37:36Z