Hello community,
My queries works fine on qlikview but whene I use the sum function , the amount become wrong as if there's redondoncy on the data here's my queries :
Transaction dis niv 1:
select tt.report_date,
tt.report_type,
tt.ALIAS_NAME,
tt.CREDIT // the amount that is wrong whene using sum function
d.ALIASNAME as alias_debit
from (
SELECT
trans.*,
tab.ALIASNAME alias_credit
FROM POS_REPORT trans , DUMP_RETAILER tab
WHERE
trans.credit_ACTOR_ID=tab.ACTORE_ID(+)
and report_type = 'TSR001'
and debited_ACTOR_ID IN ($(vActore))
AND FUNCTION = 243 ) tt,DUMP_RETAILER d
where tt.debited_actor_id=d.actore_id(+)
and tt.REPORT_DATE >= TO_DATE('01/06/2016','DD/MM/YYYY');
Transaction dis niv 2:
select
tt.report_date,
tt.report_type,
tt.ALIAS_NAME,
tt.CREDIT // the amount that is wrong whene using sum function
, d.aliasname cl2
from (
SELECT
REPORT_TYPE,
REPORT_DATE, DEBITED_ACTOR_ID,
CREDIT_ACTOR_ID,
CREDIT,
tab.ALIASNAME cl1
FROM
POS_REPORT trans,
DUMP_RETAILER tab
WHERE
trans.DEBITED_ACTOR_ID =tab.ACTORE_ID(+)
and REPORT_TYPE = 'TSR001'
AND FUNCTION = 243
and DEBITED_ACTOR_ID IN ($(vCreditActore))
AND OPER_STATE = 61
AND IERRORX = 0) tt, DUMP_RETAILER d
where
tt.CREDIT_ACTOR_ID =d.ACTORE_ID(+)
and tt.REPORT_DATE >= TO_DATE('01/06/2016','DD/MM/YYYY');
