Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
manish_kumar
Partner
Partner

Aggregation issue Pivot table

Hi

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.

1 Solution

Accepted Solutions
sunny_talwar

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]), '#.##%')

View solution in original post

4 Replies
bhaveshp90
Creator III
Creator III

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?

manish_kumar
Partner
Partner
Author

‌Hi

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

sunny_talwar

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]), '#.##%')

View solution in original post

manish_kumar
Partner
Partner
Author

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

Thanks for help...