topic Re: Count value and classify in QlikView https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715558#M475504 <HTML><HEAD></HEAD><BODY><P>Right!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> Thanks</P></BODY></HTML> Mon, 21 Jul 2014 09:10:26 GMT nboccassini 2014-07-21T09:10:26Z Count value and classify https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715555#M475501 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've a table like this:</P><P></P><TABLE border="1" class="jiveBorder" height="150" style="border: 1px solid #000000; width: 349px; height: 106px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></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>field 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>field 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>field 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>field 5</STRONG></TH></TR><TR><TD style="padding: 2px;">value 1</TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;">Y</SPAN></TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD></TR><TR><TD style="padding: 2px;">value 2</TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD></TR><TR><TD style="padding: 2px;">value 3</TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD><TD style="padding: 2px;"><STRONG>N</STRONG></TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD></TR><TR><TD>value 4</TD><TD><SPAN style="; color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD><STRONG>N</STRONG></TD><TD><STRONG>N</STRONG></TD><TD><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD><STRONG>N</STRONG></TD></TR><TR><TD>value 5</TD><TD><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD><STRONG>N</STRONG></TD><TD><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD><TD><STRONG>N</STRONG></TD><TD><SPAN style="color: #99cc00;"><STRONG>Y</STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P>I want to obtain a table:</P><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid #000000; width: 213px; height: 41px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Class</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">count</TH></TR><TR><TD style="padding: 2px;">Class A</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">Class B</TD><TD style="padding: 2px;">8</TD></TR></TBODY></TABLE><P>where A is the count of "Y" in field 1 and field 2 and b is the count of "Y" in other fields.</P><P></P><P>How??</P><P></P><P>Thanks</P></BODY></HTML> Mon, 21 Jul 2014 08:48:45 GMT https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715555#M475501 nboccassini 2014-07-21T08:48:45Z Re: Count value and classify https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715556#M475502 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P>PFA</P></BODY></HTML> Mon, 21 Jul 2014 08:56:14 GMT https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715556#M475502 tresB 2014-07-21T08:56:14Z Re: Count value and classify https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715557#M475503 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Mon, 21 Jul 2014 09:01:25 GMT https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715557#M475503 MK_QSL 2014-07-21T09:01:25Z Re: Count value and classify https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715558#M475504 <HTML><HEAD></HEAD><BODY><P>Right!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> Thanks</P></BODY></HTML> Mon, 21 Jul 2014 09:10:26 GMT https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715558#M475504 nboccassini 2014-07-21T09:10:26Z Re: Count value and classify https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715559#M475505 <HTML><HEAD></HEAD><BODY><P>Right!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> Thanks</P></BODY></HTML> Mon, 21 Jul 2014 09:10:32 GMT https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715559#M475505 nboccassini 2014-07-21T09:10:32Z Re: Count value and classify https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715560#M475506 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>may be like this.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 21 Jul 2014 09:16:25 GMT https://community.qlik.com/t5/QlikView/Count-value-and-classify/m-p/715560#M475506 ashfaq_haseeb 2014-07-21T09:16:25Z