topic Re: Counting Totals but disregarding specific Dimensions in QlikView https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99287#M752569 <HTML><HEAD></HEAD><BODY><P>As Dilip suggested use your monthfield like below:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= COUNT(DISTINCT{&lt;[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}, <STRONG>MonthField=</STRONG>&gt;}[AMS Document ID])</SPAN></P></BODY></HTML> Fri, 12 Oct 2018 18:25:05 GMT vishsaggi 2018-10-12T18:25:05Z Counting Totals but disregarding specific Dimensions https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99285#M752567 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Can someone help me with the following:</P><P></P><P>I have this expression</P><P></P><P>COUNT(DISTINCT{&lt;[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}&gt;}[AMS Document ID])</P><P></P><P>And the data is currently shown by month and Country Region</P><P></P><P>I want to show the data in another table by YTD, but i don't want the Month dimension to effect the YTD</P><P></P><P>Hope this makes sense.</P><P>Thanks in Advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99285#M752567 Anonymous 2020-11-25T16:16:04Z Re: Counting Totals but disregarding specific Dimensions https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99286#M752568 <HTML><HEAD></HEAD><BODY><P>add <EM>Month= </EM>in your set analysis</P></BODY></HTML> Fri, 12 Oct 2018 17:07:41 GMT https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99286#M752568 dplr-rn 2018-10-12T17:07:41Z Re: Counting Totals but disregarding specific Dimensions https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99287#M752569 <HTML><HEAD></HEAD><BODY><P>As Dilip suggested use your monthfield like below:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= COUNT(DISTINCT{&lt;[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}, <STRONG>MonthField=</STRONG>&gt;}[AMS Document ID])</SPAN></P></BODY></HTML> Fri, 12 Oct 2018 18:25:05 GMT https://community.qlik.com/t5/QlikView/Counting-Totals-but-disregarding-specific-Dimensions/m-p/99287#M752569 vishsaggi 2018-10-12T18:25:05Z