0 Replies Latest reply: Oct 22, 2012 12:14 PM by Anuradha Abeysuriya RSS

    convert SQl to Qlikview

    Anuradha Abeysuriya

      i have use below sql to get jasper report. So i use to get that data in to qlikview and simply display the total value.

      please help me to do it in qlikview

       

       

      SELECT A.country,

             A.order_NUM,

             A.order_DATE,

             A.item,  

             B.PAYMENT_METHOD,

             A.DATE,

             B.TOTAL_Charge,

             B.OUR_Charge

        FROM Table3 C, table2 B, table1 A

      WHERE C.Country= 'USA'

         AND B.order_SET_ID = C.order_SET_ID

         AND B.TRANSACTION_DATE =

             (SELECT MAX TRANSACTION_DATE)

                FROM table3 B2

               WHERE B2.order_SET_ID = B.order_SET_ID)

         AND A.country= C.country

         AND A.order_SET_ID = B.order_SET_ID

         AND A.DATE BETWEEN TO_DATE('01/08/2011', 'DD/MM/YYYY') AND

             TO_DATE('31/08/2011', 'DD/MM/YYYY')

         AND A.STATUS_CODE != 5

      AND  TRAFFIC_TYPE != 'M'

      ORDER  BY  TRAFFIC_TYPE, waybill_num;

       

       

      i have disign this for one country and one mounth, but that is not a must.

       

      Thanks