topic Re: Nestet aggregation in QlikView

Nestet aggregation

m_dorz — Mon, 10 Jan 2022 15:54:17 GMT

Hi,

I can't get this formula out without warning me of an error. How about the correct spelling.

=sum(sum({<[tPurchaseVoucherLine.purchaseVoucherType]={2500},[tPurchaseVoucher.purchaseVoucherState]={0}>}[tPurchaseVoucherLine.quantity])
-sum({<[tPurchaseVoucherLine.purchaseVoucherType]={2020},[tPurchaseVoucher.purchaseVoucherState]={0}>}[tPurchaseVoucherLine.quantity]))

Thanks a lot

Martin

Re: Nestet aggregation

rwunderlich — Mon, 10 Jan 2022 16:32:09 GMT

I don't think you need the outside sum(). Just

=sum({<[tPurchaseVoucherLine.purchaseVoucherType]={2500},[tPurchaseVoucher.purchaseVoucherState]={0}>}[tPurchaseVoucherLine.quantity])
-sum({<[tPurchaseVoucherLine.purchaseVoucherType]={2020},[tPurchaseVoucher.purchaseVoucherState]={0}>}[tPurchaseVoucherLine.quantity])

Re: Nestet aggregation

m_dorz — Tue, 11 Jan 2022 09:21:49 GMT

Hi,

Thanks for the info, of course I've already done this variant. The problem should not lie with the formula, but with the fact that there is no line where the result can be entered.
There are the lines where the respective condition is fulfilled, then the correct amount according to the formula is entered, but there is no line where this result can be entered. So I would have to insert a new line in which the result of this calculation can then be entered.

Re: Nestet aggregation

m_dorz — Fri, 21 Jan 2022 17:02:29 GMT

i´ll try to explain my problem once again.

the first step is shown in the following excel.

if the numbers in the "to" column match the numbers of the "from" column i want to sum up the Numbers in the "wert" column of the Lines of the matching numbers (36 +6)

now i want to substract the sum above from the value in "wert" of the first matched "to" value (50-(36+6))

i hope you can understand it better now

thanks for your replies

Martin