Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-08-09 10:37 PM

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.

Preview file
34 KB
869 Views
0 Likes
0 Replies