how to merge dimensions from different sources in qlikview

[#1]

Hi There,

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.

Thank you so much!

Best Regards,

Gloria

[#2]

Try to load your both Date fields with the same name.

reg

D

[rbecher]

Hi Gloria,

if you are sure that the invoice date equals the currency date all the time you can join the exchange rate from the exchange table to the already loaded invoice table.

- Ralf

[fkeuroglian]

Hi,

load

     CurrencyDate as Date

from xxx

load InvoiceDate as Date

from yyy

check that the format is the same in the both tables  and then you will filter and use the field DATE.

Good luck

Fernando