topic Avg(Aggr) not working in QlikView

Avg(Aggr) not working

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a expression, which works fine:

sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Fee]) /

sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Principal])

Now I want to take the avg for a time period.

So I wrote my expression as:

avg(aggr(sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Fee]) /

sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Principal]), [MonthName of Year]))

Although it doesn't show any error but my values for first and second expression remain same. Can someone tell me whats wrong with my expression.

I'm using MonthName of Year as my dimension.

Thanks for all the help.

Regards,

Aditya

Re: Avg(Aggr) not working

sunny_talwar — Thu, 03 Mar 2016 16:58:00 GMT

The change you have made would only change a number for a total. Are you expecting a change in the rows of your chart? Actually the question to ask here is, are you doing this in a chart or text box object?

Re: Avg(Aggr) not working

Thu, 03 Mar 2016 17:02:13 GMT

Hi Sunny, I'm doing it in a chart.

Re: Avg(Aggr) not working

sunny_talwar — Thu, 03 Mar 2016 17:27:37 GMT

Would you be able to share a sample with your expected output?

Re: Avg(Aggr) not working

Thu, 03 Mar 2016 18:06:08 GMT

Sure Sunny. I'll attach the sample in a new thread and tag you onto it.

Re: Avg(Aggr) not working

sunny_talwar — Thu, 03 Mar 2016 18:07:33 GMT

Sounds good

Re: Avg(Aggr) not working

Thu, 03 Mar 2016 18:12:51 GMT

Done, sent you the qvw.

Issue with avg(aggr)

Thanks for all the help..