topic How to add currency exchange into model in QlikView https://community.qlik.com/t5/QlikView/How-to-add-currency-exchange-into-model/m-p/960650#M953228 <HTML><HEAD></HEAD><BODY><P>Could You please advice me what are good practices to apply currences into model?</P><P>Should I somehow add separate table (and do calculations directly invisual design?) or add calculated amounts in proper currency to each table?</P><P>Below I attach an example. I do have two fact tables, in each there are few facts: Spare parts cost, Labour cost, Invoice cost and claimed cost, accepted cost, cost of purchase. Claims are in different currencies (fe. EUR, USD, NOK, PLN) and I have to convert them all into PLN. I have to take into account the Repair_date as a date of exchange.</P><P><BR />Maybe I should create Currency key and some foreign key like Currency &amp; Date = Currency_claim &amp; Repair date, but what next?</P><P></P><P>Will be grateful for Your help. </P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106388_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 23 Nov 2015 08:48:18 GMT 2015-11-23T08:48:18Z How to add currency exchange into model https://community.qlik.com/t5/QlikView/How-to-add-currency-exchange-into-model/m-p/960650#M953228 <HTML><HEAD></HEAD><BODY><P>Could You please advice me what are good practices to apply currences into model?</P><P>Should I somehow add separate table (and do calculations directly invisual design?) or add calculated amounts in proper currency to each table?</P><P>Below I attach an example. I do have two fact tables, in each there are few facts: Spare parts cost, Labour cost, Invoice cost and claimed cost, accepted cost, cost of purchase. Claims are in different currencies (fe. EUR, USD, NOK, PLN) and I have to convert them all into PLN. I have to take into account the Repair_date as a date of exchange.</P><P><BR />Maybe I should create Currency key and some foreign key like Currency &amp; Date = Currency_claim &amp; Repair date, but what next?</P><P></P><P>Will be grateful for Your help. </P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106388_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 23 Nov 2015 08:48:18 GMT https://community.qlik.com/t5/QlikView/How-to-add-currency-exchange-into-model/m-p/960650#M953228 2015-11-23T08:48:18Z