3 Replies Latest reply: Jun 2, 2014 5:31 PM by Fernando Keuroglian RSS

    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