7 Replies Latest reply: Dec 22, 2010 5:47 AM by Abhijit Bansode RSS

    Joining two tables in qlikview script

    Abhijit Bansode

      Hi, i want to filter data based upon two tables, for this i need to perform join query in database level.

      but, i want to achieve the same at qlikview modelling level . pls hepl me how to achieve this.

      below is the query i'm using at database level and its producing desired results:

      SELECT

      B.RECYM,

      B.PRODUCT,

      B.SALESORDER,

      A.ADJST_RNTL_AMNT-B.ADJST_RNTL_AMNT

      FROM

      CANCL_AMT A,

      TEMP B

      WHERE

      B.RECYM=(A.RECYM+1) AND

      B.PRODUCT=A.PRODUCT AND

      B.SALESORDER=A.SALESORDER;