Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to merge dimensions from different sources in qlikview

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

3 Replies
Not applicable

Re: how to merge dimensions from different sources in qlikview

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

reg

D

MVP
MVP

Re: how to merge dimensions from different sources in qlikview

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
Honored Contributor

Re: how to merge dimensions from different sources in qlikview

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

Community Browser