Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anuradhaa
Not applicable

convert SQl to Qlikview

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