topic Set Analysis - Pivot Table Chart Object Not Average Nulls in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Pivot-Table-Chart-Object-Not-Average-Nulls/m-p/267786#M100568 <HTML><HEAD></HEAD><BODY><P>Trying to build a chart where the divisions are averaged by date and combined for a total average for each date.&nbsp; In the attached example the chart object is not including the nulls when it totals the averages.&nbsp; Any suggestions?</P></BODY></HTML> Sat, 22 Oct 2011 01:11:56 GMT 2011-10-22T01:11:56Z Set Analysis - Pivot Table Chart Object Not Average Nulls https://community.qlik.com/t5/QlikView/Set-Analysis-Pivot-Table-Chart-Object-Not-Average-Nulls/m-p/267786#M100568 <HTML><HEAD></HEAD><BODY><P>Trying to build a chart where the divisions are averaged by date and combined for a total average for each date.&nbsp; In the attached example the chart object is not including the nulls when it totals the averages.&nbsp; Any suggestions?</P></BODY></HTML> Sat, 22 Oct 2011 01:11:56 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Pivot-Table-Chart-Object-Not-Average-Nulls/m-p/267786#M100568 2011-10-22T01:11:56Z