topic Re: Aggregation issue Pivot table in QlikView

Aggregation issue Pivot table

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

I am getting some issue in doing Aggregation in expression.

My dimension is a calculated dimension but when I am aggregating it in the Expression I am not able to reduce the aggr field.

Please fine the attached excle file having the desired output and QV app for the code.

Re: Aggregation issue Pivot table

bhaveshp90 — Tue, 23 Oct 2018 18:53:57 GMT

Hello, Please explain what you are trying to get here? Is it Column H from the Excel, you are trying to get the expression for?

Re: Aggregation issue Pivot table

manish_kumar — Tue, 23 Oct 2018 19:34:41 GMT

‌Hi

I want 5.26% in the yield column against total row..

Re: Aggregation issue Pivot table

sunny_talwar — Tue, 23 Oct 2018 19:57:23 GMT

Do you need this in a text box object? Try this

=Num(Sum(Aggr(Sum({<Duration={'<=1'}>}[Amortised Book Value])*sum([AWAC Yield]), Category, [Company Name], [Security Name], [Maturity Date], Month))/Sum({<Duration={'<=1'}>}[Amortised Book Value]), '#.##%')

Re: Aggregation issue Pivot table

manish_kumar — Thu, 25 Oct 2018 06:33:45 GMT

I need that in table subtotal only. But your expression had worked for me in that also.

Thanks for help...