Remove Currency code field from any one table other than Currency table.
You can go with this
Billing Billing Number ** PeriodMonthBilling PeriodYearBilling CurrencyCode * AmountBilling Billing Number & CurrencyCode as KeyField
Append Billing Number & CurrencyCode and make that as key field.
Collection Collection Number PeriodMonthCollection PeriodYearCollection BIllingNumber & CurrencyCode as KeyField AmountCollection BankFrom
Append Billing Number & CurrencyCode as Key field Remove the Billing number and Currency code fields.
Currency CurrencyCode * PeriodMonth PeriodYear Exchange rate
Thanks for your fast and accurate answer.
Sorry, but my table does not have enough information.
Your answers are very helpful, but not answered my question because of errors Foreign Key (my information is wrong)
The correct table :
Note : PeriodMonthBilling/PeriodYearBilling not same as PeriodMonthCollection/PeriodYearCollection
Billing Billing Number ** PeriodMonthBilling * PeriodYearBilling * CurrencyCode * AmountBilling Collection Collection Number PeriodMonthCollection * PeriodYearCollection * CurrencyCode * AmountCollection BankFrom BIllingNumber ** Currency CurrencyCode * PeriodMonth * PeriodYear * Exchange rate
relationship of these three tables are
table billing is a data about bill, after bill is paid it will be noted in the table collection.
table currency is used to record the value of the currency exchange rate at the time of billing or at the time carried on doing paid.
Is there a solution other than using a join?
Do Join the Qlikview pretty fast when compared to regular table link?
Thanks for your quick answer.
CurrencyCode is the same, but if the transaction is carried out in different months, then the exchange rate can be different. So for the billing and collection can have a different exchange rate. (Example: billing can occur in the month of january 2012, but the collection took place in February 2012).