topic Re: Count distinct rows into a group in QlikView https://community.qlik.com/t5/QlikView/Count-distinct-rows-into-a-group/m-p/104338#M16448 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Count(TOTAL &lt;Group&gt; DISTINCT FIELD1&amp;FIELD2&amp;FIELD3)</STRONG></P></BODY></HTML> Mon, 15 Oct 2018 11:18:47 GMT sunny_talwar 2018-10-15T11:18:47Z Count distinct rows into a group https://community.qlik.com/t5/QlikView/Count-distinct-rows-into-a-group/m-p/104337#M16447 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="175" style="border: 1px solid #000000; width: 405px; height: 175px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Group</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FIELD1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG>FIELD2</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG>FIELD3</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ff0000;"><STRONG>COUNT</STRONG></SPAN></TH></TR><TR><TD style="padding: 2px;">GROUP1</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">2</SPAN></TD></TR><TR><TD style="padding: 2px;">GROUP1</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">2</SPAN></TD></TR><TR><TD style="padding: 2px;">GROUP1</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">2</SPAN></TD></TR><TR><TD style="padding: 2px;">GROUP2</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">3</SPAN></TD></TR><TR><TD style="padding: 2px;">GROUP2</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">3</SPAN></TD></TR><TR><TD>GROUP2</TD><TD>B</TD><TD>B</TD><TD>B</TD><TD><SPAN style="color: #ff0000;">3</SPAN></TD></TR><TR><TD>GROUP2</TD><TD>C</TD><TD>C</TD><TD>C</TD><TD><SPAN style="color: #ff0000;">3</SPAN></TD></TR></TBODY></TABLE><P></P><P>Hi</P><P>by the above table, I would calculate, in a expression into pivot chart,&nbsp; the field "COUNT" that has to count the distinct row (FIELD1, FIELD2, FIELD3) within each&nbsp; "GROUP"</P><P></P><P>Can anyone help me ?</P><P>Thanks</P></BODY></HTML> Mon, 15 Oct 2018 10:06:54 GMT https://community.qlik.com/t5/QlikView/Count-distinct-rows-into-a-group/m-p/104337#M16447 andrew001 2018-10-15T10:06:54Z Re: Count distinct rows into a group https://community.qlik.com/t5/QlikView/Count-distinct-rows-into-a-group/m-p/104338#M16448 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Count(TOTAL &lt;Group&gt; DISTINCT FIELD1&amp;FIELD2&amp;FIELD3)</STRONG></P></BODY></HTML> Mon, 15 Oct 2018 11:18:47 GMT https://community.qlik.com/t5/QlikView/Count-distinct-rows-into-a-group/m-p/104338#M16448 sunny_talwar 2018-10-15T11:18:47Z