5 Replies Latest reply: Nov 25, 2013 10:22 AM by Michael Solomovich RSS

    Linked Tables - How to specify which table data come from?

      Hi,

       

      I have two tables linked together by Item ID. Table A has three Items while Table B has 5 items. There are 2 common items shared between table A and table B, 1 extra items from Table A and 3 from Table B. When I try to use Item ID as dimension it returns all 6 different Items but I need the 5 items from table B. Is there a way to specify from which table the data come? Thanks!

       

      Table A        Table B

      1                    1

      2                    2

      3                    5

                            6

                            7
      Now Qlikview returns 1,2,3,5,6,7 but I only want 1,2,5,6,7 from Table B as my dimension.