help multiple data showing

qlikmpate0 — Wed, 02 May 2018 10:03:31 GMT

I'm trying to create an aged trial balance as a qlikview document where for each collector display customers they are responsible for and the customers credit limit and outstanding balance across different buckets.

I have managed to get all the data but I'm seeing duplicate rows where sometimes the currency at invoice level and credit level are different, when a check the same currency I still get rows where the legal entity is missing.

this is the sql I'm working off:-

SELECT

a.cust_account_id,

b.cust_account_id,

c.customer_number,

c.customer_name,

g.party_site_number,

d.location,

a.overall_credit_limit,

d.site_use_id,

SUM (e.amount_due_remaining) credit_balance

FROM HZ_CUST_PROFILE_AMTS a,

HZ_CUST_ACCOUNTS b,

ar_customers c,

hz_cust_site_uses_all d,

ar_payment_schedules_all e,

hz_cust_acct_sites_all f,

hz_party_sites g

WHERE overall_credit_limit IS NOT NULL

AND a.cust_account_id = b.cust_account_id

AND b.account_number = c.customer_number

AND a.site_use_id = d.site_use_id

AND c.customer_id = e.customer_id

AND d.site_use_id = e.customer_site_use_id

and c.customer_number = 'FR301758'

AND d.cust_acct_site_id = f.cust_acct_site_id

AND g.party_site_id = f.party_site_id

AND e.org_id = 364

GROUP BY a.cust_account_id,

b.cust_account_id,

c.customer_name,

c.customer_number,

d.site_use_id,

d.location,

a.overall_credit_limit,

g.party_site_number

ORDER BY CUSTOMER_NAME

can anyone help please.

I have attached my qlikview document and this is one example I only want to see the highlighted row, I think I may have a connection missing somewhere not sure where. thanks in advance.

regards

topic help multiple data showing in QlikView

help multiple data showing