topic Re: How to Aggregate Total on Expression Straight Table? in QlikView

How to Aggregate Total on Expression Straight Table?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to Aggregate Total on Expression Straight Table?

tresB — Wed, 02 May 2018 05:23:04 GMT

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

Re: How to Aggregate Total on Expression Straight Table?

debabrata_sahoo — Wed, 02 May 2018 05:26:39 GMT

Can you please tell me what you written in expression.

Re: How to Aggregate Total on Expression Straight Table?

Anonymous — Wed, 02 May 2018 07:07:59 GMT

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

Re: How to Aggregate Total on Expression Straight Table?

sunny_talwar — Wed, 02 May 2018 09:17:33 GMT

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

Re: How to Aggregate Total on Expression Straight Table?

Anonymous — Wed, 02 May 2018 19:02:48 GMT

‌Just the table

[Transactions.Invoiced Quantity]

Re: How to Aggregate Total on Expression Straight Table?

Anonymous — Wed, 02 May 2018 19:05:20 GMT

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

Re: How to Aggregate Total on Expression Straight Table?

Anonymous — Wed, 02 May 2018 19:12:22 GMT

‌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

Re: How to Aggregate Total on Expression Straight Table?

sunny_talwar — Wed, 02 May 2018 19:36:17 GMT

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

Re: How to Aggregate Total on Expression Straight Table?

Anonymous — Thu, 03 May 2018 02:53:31 GMT

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.

Re: How to Aggregate Total on Expression Straight Table?

shansundar — Thu, 03 May 2018 10:30:41 GMT

Looks like there is an issue in your data model join which duplicates the invoiced quantity (4 times) and that's what summing up in the front end.

Is all fields in the straight table 1 (dimension & expression) are from same table in data model or different ones.

Thanks,

Shan S