Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My Table 1 total sum up amount now display 17,030.34 , How to make it display 31,287?
Paul
Just need to use Sum(Aggr())
Sum(Aggr(If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=151'} >}total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,
Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=151'} >}total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))), CUST_ID, company_ar))
my QVF
I am seeing a total of 140,011.38.... Do I need to make a selection to see 17,030.34?
Hi Sunny
Yes , pls select :-
Source = TDSS
GROUP CLASS = G3
Paul
Get Outlook for iOS<https://aka.ms/o0ukef>
Just need to use Sum(Aggr())
Sum(Aggr(If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=151'} >}total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,
Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=151'} >}total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))), CUST_ID, company_ar))
Hi Sunny
You are good.
Any idea why in Qlik View ver 9 the old expression with out sum(AGGR it work fine,
Paul
Nope, no idea