7 Replies Latest reply: Apr 8, 2015 12:56 PM by Shelley Smith RSS

    Average per Month Issue

    Mike Neidlinger

       

      While updating a straight table, I noticed an issue that relates to a Monthly Average that I have not been able to figure out.   Our Month field is based on our facts table so we only have a month record if there was a dollar amount recorded for that month.   So if we count the months to get an average for the first quarter, it only averages based on actual recorded months instead of the selected three months.  I have tried to use the GetSelectedCount and the GetPossibleCount to work but they also have limitations and do not work in all instances.

       

      I created a simple Qlikview app to demonstrate the issue.  In the sample Jill only has two data points so when I select all three months her average(Average Possible ) is correct when we include John's data.  As soon as we select 'Jill' the Possible count switches to 2 months and therefore does not include the average for the first quarter.

       

      Any help would be appreciated.