topic Re: Count Field Value Occurrences in QlikView https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51480#M782866 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG>Count(DISTINCT Name&amp;Date&amp;Value)</STRONG></P></BODY></HTML> Mon, 19 Mar 2018 18:20:37 GMT sunny_talwar 2018-03-19T18:20:37Z Count Field Value Occurrences https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51478#M782864 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" height="212" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl70" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">Name </TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="57">Date</TD><TD class="xl68" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;" width="64">Value</TD><TD class="xl68" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">ID</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="57">1/1/2017</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;">0</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Ax</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="57">1/1/2017</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;">0</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Ay</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="57">1/1/2017</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Az</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="57">1/1/2017</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;">0</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Bx</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">B&nbsp; </TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="57">1/1/2017</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">By</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">B</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1/2/2017</TD><TD align="right" class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;">0</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Bz</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" colspan="4" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit; text-align: center;"><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">The Count of Value should give me 5</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">(0 for A (1/1/2017), 1 for A (1/1/2017), 0 for B (1/1/2017), 1 for B (1/1/2017), 0 for B (1/2/2017)</P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51478#M782864 qlikwiz123 2020-11-25T16:16:04Z Re: Count Field Value Occurrences https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51479#M782865 <HTML><HEAD></HEAD><BODY><P>May be this -</P><P>Count(Aggr(Count(Distinct Value),Name))</P></BODY></HTML> Mon, 19 Mar 2018 18:17:00 GMT https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51479#M782865 Digvijay_Singh 2018-03-19T18:17:00Z Re: Count Field Value Occurrences https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51480#M782866 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG>Count(DISTINCT Name&amp;Date&amp;Value)</STRONG></P></BODY></HTML> Mon, 19 Mar 2018 18:20:37 GMT https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51480#M782866 sunny_talwar 2018-03-19T18:20:37Z Re: Count Field Value Occurrences https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51481#M782867 <HTML><HEAD></HEAD><BODY><P>Thank you Digvijay. That was really helpful.</P></BODY></HTML> Mon, 19 Mar 2018 19:31:48 GMT https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51481#M782867 qlikwiz123 2018-03-19T19:31:48Z Re: Count Field Value Occurrences https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51482#M782868 <HTML><HEAD></HEAD><BODY><P>Thanks <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ That helped.</P></BODY></HTML> Mon, 19 Mar 2018 19:32:16 GMT https://community.qlik.com/t5/QlikView/Count-Field-Value-Occurrences/m-p/51482#M782868 qlikwiz123 2018-03-19T19:32:16Z