https://community.qlik.com/t5/App-Development/Aggr-Count-Distinct-and-Ignore-Dimension/m-p/1526324#M37830 <P>Hi there,</P><P>&nbsp;</P><P>Please can I ask how I would get the results of the measure but across all dimensions (Mth-Year)?</P><P>Pivot Dimensions and Measure attached.</P><UL><LI>Dimension: Authority ID</LI><LI>Dimension: Mth-Year</LI><LI>Measure:&nbsp;=Aggr(count(distinct [Mth-Year]),[Authority ID])</LI></UL><P>It is only showing within the first Mth-Year for which there was data for each authority.</P><P>With Thanks</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pivot.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3037i2C181260A917A746/image-size/large?v=v2&amp;px=999" role="button" title="pivot.PNG" alt="pivot.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="measure.PNG" style="width: 450px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3038i770CC1AFCB9F0540/image-size/large?v=v2&amp;px=999" role="button" title="measure.PNG" alt="measure.PNG" /></span></P> Sat, 16 Nov 2024 06:56:12 GMT cmorri1988 2024-11-16T06:56:12Z https://community.qlik.com/t5/App-Development/Aggr-Count-Distinct-and-Ignore-Dimension/m-p/1526324#M37830 <P>Hi there,</P><P>&nbsp;</P><P>Please can I ask how I would get the results of the measure but across all dimensions (Mth-Year)?</P><P>Pivot Dimensions and Measure attached.</P><UL><LI>Dimension: Authority ID</LI><LI>Dimension: Mth-Year</LI><LI>Measure:&nbsp;=Aggr(count(distinct [Mth-Year]),[Authority ID])</LI></UL><P>It is only showing within the first Mth-Year for which there was data for each authority.</P><P>With Thanks</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pivot.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3037i2C181260A917A746/image-size/large?v=v2&amp;px=999" role="button" title="pivot.PNG" alt="pivot.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="measure.PNG" style="width: 450px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3038i770CC1AFCB9F0540/image-size/large?v=v2&amp;px=999" role="button" title="measure.PNG" alt="measure.PNG" /></span></P> Sat, 16 Nov 2024 06:56:12 GMT https://community.qlik.com/t5/App-Development/Aggr-Count-Distinct-and-Ignore-Dimension/m-p/1526324#M37830 cmorri1988 2024-11-16T06:56:12Z https://community.qlik.com/t5/App-Development/Aggr-Count-Distinct-and-Ignore-Dimension/m-p/1526326#M37831 <P>Maybe try this</P><PRE>=Aggr(<FONT color="#FF0000">NODISTINCT</FONT> Count(DISTINCT [Mth-Year]), [Authority ID])</PRE> Fri, 04 Jan 2019 12:20:45 GMT https://community.qlik.com/t5/App-Development/Aggr-Count-Distinct-and-Ignore-Dimension/m-p/1526326#M37831 sunny_talwar 2019-01-04T12:20:45Z