topic Expression Average Total in Pivot in QlikView https://community.qlik.com/t5/QlikView/Expression-Average-Total-in-Pivot/m-p/790997#M1034984 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I have a pivot chart with expressions that calculates the average customer visits as per the below formula:</P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">avg(aggr(Count({$&lt;DocType={'3'}&gt;} DISTINCT CustCode),SmCode,Date))</SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">My problem is that the total (partial sum) is not being calculated properly as it doesn't count the dates that have zero visits as shown below:</SPAN></P><P>can you pls help me that?</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76606_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 29 Jan 2015 16:16:52 GMT 2015-01-29T16:16:52Z Expression Average Total in Pivot https://community.qlik.com/t5/QlikView/Expression-Average-Total-in-Pivot/m-p/790997#M1034984 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I have a pivot chart with expressions that calculates the average customer visits as per the below formula:</P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">avg(aggr(Count({$&lt;DocType={'3'}&gt;} DISTINCT CustCode),SmCode,Date))</SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">My problem is that the total (partial sum) is not being calculated properly as it doesn't count the dates that have zero visits as shown below:</SPAN></P><P>can you pls help me that?</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76606_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 29 Jan 2015 16:16:52 GMT https://community.qlik.com/t5/QlikView/Expression-Average-Total-in-Pivot/m-p/790997#M1034984 2015-01-29T16:16:52Z