topic Re: How to use the Count Function that refers to a specific Object in QlikView https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364664#M417833 <HTML><HEAD></HEAD><BODY><P>You can't reference the output of a chart (expression column) from another chart.</P><P></P><P>But you can create a virtual table with your expression using advanced aggregation and count the 'Y', something like</P><P></P><P>=Sum( Aggr( If( <EM>YourObjectExpresssion</EM> = 'Y',1,0), [Student Name])</P><P></P><P>Replace the italic part with the expression that returns 'Y' or blank for each student.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3857">QlikView Technical Brief - AGGR.docx</A></P></BODY></HTML> Wed, 17 May 2017 22:13:11 GMT swuehl 2017-05-17T22:13:11Z How to use the Count Function that refers to a specific Object https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364663#M417832 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Let me start use an example to better explain myself.</P><P></P><P>I have the following table:</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Object Id: O23</STRONG></SPAN></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid rgb(0, 0, 0); width: 195px; height: 127px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Student Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Attendance</TH></TR><TR><TD style="padding: 2px;">Tom</TD><TD style="padding: 2px; text-align: center;">Y</TD></TR><TR><TD style="padding: 2px;">Steve</TD><TD style="padding: 2px; text-align: center;"><EM>blank</EM></TD></TR><TR><TD style="padding: 2px;">Jackie</TD><TD style="padding: 2px; text-align: center;">Y</TD></TR><TR><TD style="padding: 2px;">Steph</TD><TD style="padding: 2px; text-align: center;">Y</TD></TR></TBODY></TABLE><P></P><P>I need to have a separate Text Object that Counts the amount of Attendance's <STRONG>specific</STRONG> to this table. Please let me know what the best expression would to solve this. <SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Many Thanks!</SPAN></P></BODY></HTML> Wed, 17 May 2017 21:33:31 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364663#M417832 kfahri342 2017-05-17T21:33:31Z Re: How to use the Count Function that refers to a specific Object https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364664#M417833 <HTML><HEAD></HEAD><BODY><P>You can't reference the output of a chart (expression column) from another chart.</P><P></P><P>But you can create a virtual table with your expression using advanced aggregation and count the 'Y', something like</P><P></P><P>=Sum( Aggr( If( <EM>YourObjectExpresssion</EM> = 'Y',1,0), [Student Name])</P><P></P><P>Replace the italic part with the expression that returns 'Y' or blank for each student.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3857">QlikView Technical Brief - AGGR.docx</A></P></BODY></HTML> Wed, 17 May 2017 22:13:11 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364664#M417833 swuehl 2017-05-17T22:13:11Z Re: How to use the Count Function that refers to a specific Object https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364665#M417834 <HTML><HEAD></HEAD><BODY><P>Is you are expecting output as Three?</P></BODY></HTML> Thu, 18 May 2017 01:35:54 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-Count-Function-that-refers-to-a-specific-Object/m-p/1364665#M417834 Anil_Babu_Samineni 2017-05-18T01:35:54Z