topic Issue with avg(aggr) in QlikView

Issue with avg(aggr)

Wed, 25 Nov 2020 16:16:04 GMT

For Jan 2016 the value is fine. When it comes to Feb I want to show the avg of Jan and Feb.

Present:

Jan 2016 Feb 2016

11445.36 11544.28

Expected:

Jan 2016 Feb 2016

11445.36 11494.82

Note: In the chart I only want to show data for current year.

Regards,

Aditya

sunny_talwar — Thu, 03 Mar 2016 18:12:32 GMT

Try this:

RangeAvg(Above(sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]),-1)))"}>} [New Issuance Principal])/

Sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]),-1)))"}>}[New Issuance]), 0, RowNo()))

Thu, 03 Mar 2016 18:17:00 GMT

Sunny but going forward, say for Mar will the value be

Jan 2016 Feb 2016 Mar2016

11445.36 11494.82 Avg(11445.36+11494.82+value(Mar2016))

sunny_talwar — Thu, 03 Mar 2016 18:18:21 GMT

Yes it will be

sunny_talwar — Thu, 03 Mar 2016 18:19:04 GMT

In its current state, the expression will continue to do RangeAvg() forever