topic Re: Running average needs to be specific for each Branch code in QlikView

Running average needs to be specific for each Branch code

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

Hi Guys,

Could you please guide me to fix the running average (Net claims) for each BR Code separately. In other words after seven months the total row should carry the average total & for the next Branch it should start again from the Jan figure of the said Branch etc.

Thanks

Neville

Re: Running average needs to be specific for each Branch code

sunny_talwar — Tue, 20 Aug 2019 17:00:01 GMT

Try this

RangeAvg( Above( Sum({<DESCRIPTION = {'NET CLAIM'}>} MONTH_ACT) , 0, RowNo()) )

Re: Running average needs to be specific for each Branch code

nevilledhamsiri — Tue, 20 Aug 2019 17:50:50 GMT

Thanks sunny, That is fine. Also will you suggest how I get the total row arranged in total average. Right now it is in blank. If Aggr to bring in how the string to be arranged. Eg AS Total should be Rs 3,003,852

Thanks

Re: Running average needs to be specific for each Branch code

sunny_talwar — Tue, 20 Aug 2019 17:57:05 GMT

This

Sum(Aggr( RangeAvg( Above( Sum({<DESCRIPTION = {'NET CLAIM'}>} MONTH_ACT) , 0, RowNo()) ) , BR_CODE, TRN_MONTH))

Re: Running average needs to be specific for each Branch code

nevilledhamsiri — Tue, 20 Aug 2019 18:03:05 GMT

Thank you very much. It provided what I looked forward to

Neville