topic how to merge dimensions from different sources in qlikview in QlikView

how to merge dimensions from different sources in qlikview

Mon, 02 Jun 2014 20:27:29 GMT

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

Re: how to merge dimensions from different sources in qlikview

Mon, 02 Jun 2014 21:22:44 GMT

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

reg

Re: how to merge dimensions from different sources in qlikview

rbecher — Mon, 02 Jun 2014 21:30:51 GMT

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

Re: how to merge dimensions from different sources in qlikview

fkeuroglian — Mon, 02 Jun 2014 21:31:14 GMT

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