Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marishnagendran
Creator
Creator

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
sunny_talwar

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

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

 

View solution in original post

4 Replies
sunny_talwar

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

Sum(Aggr([Invoice Amount], Trx_ID)
marishnagendran
Creator
Creator
Author

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

 

sunny_talwar

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

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

 

marishnagendran
Creator
Creator
Author

Thank you its working