Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Question: Calculating Average Balance for Actual Days Outstanding

Hello all, need your help. 

I have an app that needs to calculate the average loan balance outstanding for the month.  However, I cannot simply take the average of the sum of the daily balance and divide by the number of calendar days in the month, since these loans are only outstanding for a few days--it is a stock lending operation.  What I need is to calculate the balance only for the days that the loan is actually outstanding during the month. 

I developed this generic example.  I copy and paste an image below, and also attach this example as an Excel file. 

DB_QV_ActualDays.jpg

As shown, I want the Actual Average by Days Outstanding in Row 36.  This Average I calculated using CountIF in Excel.  I don't know how to do so in QlikView. 

Any advice and comments would be welcomed. 

Thanks.

Community Browser