Discussion board where members can get started with Qlik Sense.
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
But its not working
My Scenario is Based on Trx_ID i want to calculate invoice amount my dimension is Customer Name
Go to Solution.
Did you give this a shot... missed an additional closing parenthesis at the end....
Sum(Aggr([Invoice Amount], Trx_ID))
Not sure I understand completely, but may be you need this
Sum(Aggr([Invoice Amount], Trx_ID)
Every day we are maintains invoice table history.
For Example, I'm taking one customer invoice id i.e(Trx_ID)
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
Thank you its working