topic Aggregation in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846296#M297099 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>In the attached image I have a table that shows 29 activations, these are actually made up of activations across three dates. The business now only want to count activations made on the same day as 1. </P><P></P><P>Ideally the business want to see the top chart "Current View - Pivot" but instead of 29 it should read 3.</P><P></P><P>I can achieve this if I include the date but the business don't want to see this level of detail.</P><P></P><P>I'm trying to achieve this without adding or changing the underlying model.</P><P></P><P>Any thoughts would be gratefully received.</P><P></P><P>Kind regards</P><P></P><P>Darrell<IMG alt="Pivot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/82808_Pivot.PNG" style="height: 242px; width: 620px;" /> </P></BODY></HTML> Thu, 02 Apr 2015 15:17:36 GMT darrellbutler 2015-04-02T15:17:36Z Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846296#M297099 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>In the attached image I have a table that shows 29 activations, these are actually made up of activations across three dates. The business now only want to count activations made on the same day as 1. </P><P></P><P>Ideally the business want to see the top chart "Current View - Pivot" but instead of 29 it should read 3.</P><P></P><P>I can achieve this if I include the date but the business don't want to see this level of detail.</P><P></P><P>I'm trying to achieve this without adding or changing the underlying model.</P><P></P><P>Any thoughts would be gratefully received.</P><P></P><P>Kind regards</P><P></P><P>Darrell<IMG alt="Pivot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/82808_Pivot.PNG" style="height: 242px; width: 620px;" /> </P></BODY></HTML> Thu, 02 Apr 2015 15:17:36 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846296#M297099 darrellbutler 2015-04-02T15:17:36Z Re: Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846297#M297100 <HTML><HEAD></HEAD><BODY><P>May be</P><P>SUM(Aggr(COUNT(Distinct Date),Field))</P></BODY></HTML> Thu, 02 Apr 2015 15:25:56 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846297#M297100 MK_QSL 2015-04-02T15:25:56Z Re: Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846298#M297101 <HTML><HEAD></HEAD><BODY><P>I'm not sure if this could be the right solution for your problem but have you tried to count Combined_Table_Date?</P></BODY></HTML> Thu, 02 Apr 2015 15:27:40 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/846298#M297101 mrossoit 2015-04-02T15:27:40Z