5 Replies Latest reply: Sep 19, 2013 10:37 AM by juliano juli RSS

    where exists help

      Hi, i have this situation::

       

      TableA:

      number    nameA

      1    aaaa

      2    bbbb

      3    cccc   

      4    dddd

      5    ffff

      6    gggg

       

       

      tableB:

      number    nameB

      1    XXXXX

      2    YYYYY

      5    RRRRR

       

       

      I want to show in qlikview TableA and TableB, but in TableB only the rows that number from TableB exist in TableA. The way it is now, it shows:

      1    XXXXX

      2    YYYYY

      3    -

      4    -

      5    RRRRR

      6    -

       

      How can I do that? Is there a way to do without create a 3rd table ? maybe with "where exists", but how?

       

      thanks