Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marishnagendran
Contributor

Using Aggr

Hi All,

PFA File.

In That Customer name is my dimension.For measure i want to take invoice amount.

In that table structure we are maintaining history but in front end i want to take calculate one invoice amount i.e(1500)

Dimension is Customer_Name

I'm using expression as

Aggr(Sum(Invoice Amount),Trx_ID)

But its not working

My Scenario is Based on Trx_ID i want to calculate invoice amount my dimension is Customer Name

1 Solution

Accepted Solutions

Re: Using Aggr

Did you give this a shot... missed an additional closing parenthesis at the end....

Sum(Aggr([Invoice Amount], Trx_ID))

 

4 Replies

Re: Using Aggr

Not sure I understand completely, but may be you need this

Sum(Aggr([Invoice Amount], Trx_ID)
marishnagendran
Contributor

Re: Using Aggr

Every day we are maintains invoice table history.

For Example, I'm taking one customer invoice id i.e(Trx_ID)

Customer NameTrx_IDInvoice AmountLoad Date
A123150001-Apr-19
A123150002-Apr-19
A123150003-Apr-19
A123150004-Apr-19
A123150005-Apr-19
A123150006-Apr-19

 

The customer bought one time only but we are maintaining history so the records are repeating

Now i want to sum the invoice amount based on customer name.

I need a output like 

For A customer the invoice amount is 1500

 

Re: Using Aggr

Did you give this a shot... missed an additional closing parenthesis at the end....

Sum(Aggr([Invoice Amount], Trx_ID))

 

marishnagendran
Contributor

Re: Using Aggr

Thank you its working