Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

How to make my table total display 31,287?

Hi All

My Table 1 total sum up amount now display 17,030.34 , How to make it display 31,287?

Paul

1 Solution

Accepted Solutions

Re: How to make my table total display 31,287?

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))

6 Replies
paulyeo11
Valued Contributor II

Re: How to make my table total display 31,287?

my QVF

Re: How to make my table total display 31,287?

I am seeing a total of 140,011.38.... Do I need to make a selection to see 17,030.34?

paulyeo11
Valued Contributor II

Re: How to make my table total display 31,287?

Hi Sunny

Yes , pls select :-

Source = TDSS

GROUP CLASS = G3

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

Re: How to make my table total display 31,287?

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))

paulyeo11
Valued Contributor II

Re: How to make my table total display 31,287?

Hi Sunny

You are good.

Any idea why in Qlik View ver 9 the old expression with out sum(AGGR it work fine,

Paul

Re: How to make my table total display 31,287?

Nope, no idea

Community Browser