Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Running average needs to be specific for each Branch code

 

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 

1 Solution

Accepted Solutions
Highlighted

This

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

View solution in original post

4 Replies
Highlighted

Try this

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

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

Highlighted

This

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

View solution in original post

Highlighted
Specialist
Specialist

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

Neville