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