3 Replies Latest reply: Mar 8, 2014 5:04 AM by Christian Lauritzen RSS

    How to select values in Table A that are not in Table B in script?

    Christian Lauritzen

      How do I do this in Qlikview?

       

      Example:

      Table A_

      ItemNo

      x1

      x2

      x3

      x4

       

      Table B

      ItemNo

      x1

      x3

      x4

       

      How do I write a query (using Resident as both tables are already read) in the script that results in:

      ItemNo

      x3

       

      as x3 is the only value that only exists in Table A