How to Aggregate Total on Expression Straight Table?

[Anonymous]

     Hi please help me with the Aggregate Expression formula. New to QlikView thanks.

[tresesco]

Could you share your sample qvw, or, at least the expressions being used at both the places you marked?

[debabrata_sahoo]

Can you please tell me what you written in expression.

[Anonymous]

This is the best I get hope it is clear illustrated tresesco‌

[sunny_talwar]

May be this

Sum(Aggr([Transactions.Quantity With Sign], [Transactions.Transaction Date], [Transactions.Ref Number], [Transactions.Item Full Name], [Transactions.Transaction Line Order], [Transactions.Amount With Sign]))

[Anonymous]

‌Just the table

[Transactions.Invoiced Quantity]

[Anonymous]

‌Hi Sir is this to Aggregate the total of [Transactions.Invoiced Quantity] per line on the straight table 1? thanks

[Anonymous]

‌I want to aggregate the total [transactions.Invoiced Quantity] per line. is that possible? because the result goes 4times of the actual per item ID. only on the Straight table 1

[sunny_talwar]

Not sure I understand your question? Is the above expression not working?

[Anonymous]

Thank you for your help. Appreciated.

I try the syntax you've share, the result aggregate the Qty not the Quantity Invoiced.

The Straight Table 1 needs to fixed I encircled the expression needs to fixed.

The Straight Table 2 is correct already.