3 Replies Latest reply: Dec 25, 2011 12:50 AM by Daniel Lederman RSS

    Role Playing Dimensions (not dates)

    Daniel Lederman

      I am new to Qlikview and came into a problem I can't seem to be able to solve.

       

      I have a dimension of Banks (with the Bank code, the name and some other information). One of my fact tables is a table of account transfers from one bank to another. In this table I have one column for the Bank that transfers the account and one column for the Bank that receives the account. One Bank can play one role in one transfer and another in different transaction.

       

      If I try to create two key fields in the dimension table with Tranfering_Bank and Receiving_Bank, I get an automatic synthetic key pointing to the fact table (not the desired effect). If I create two Bank dimensions (one for Transfering Bank and another for Receiving Bank) then I cannot filter by Bank and get aggregation information for each bank (like the net transfers - received minus transfers ceded).

       

      Thank you for anyone that can help.