how to merge dimensions from different sources in qlikview
I need to merge two dimensions just like SAP BO. For example. the dimension InvoiceDate is from dbo.invoice in sql1, the dimension CurrencyDate is from exchange table in sql 7. How can I merge these two dimensions in qlikview so that when the specific Invoicedate is chosen, the same currency date is chosen as well.