topic Re: TableBox in QlikView https://community.qlik.com/t5/QlikView/TableBox/m-p/1451718#M809711 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=<STRONG>Count(</STRONG>aggr(If(TStatus='Closed','NA', </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">only({$&lt;Flag={0},[TStatus]={'Open'}&gt;}TNumber)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">),TNumber)<STRONG>)</STRONG></SPAN></P></BODY></HTML> Sun, 15 Oct 2017 09:42:36 GMT Anil_Babu_Samineni 2017-10-15T09:42:36Z TableBox https://community.qlik.com/t5/QlikView/TableBox/m-p/1451717#M809710 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I am using KPI object to show the count of expression ,but my user want that details below the table box also</P><P></P><P>am using this expression working fine</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/TableBox/m-p/1451717#M809710 soniasweety 2020-11-25T16:16:04Z Re: TableBox https://community.qlik.com/t5/QlikView/TableBox/m-p/1451718#M809711 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=<STRONG>Count(</STRONG>aggr(If(TStatus='Closed','NA', </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">only({$&lt;Flag={0},[TStatus]={'Open'}&gt;}TNumber)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">),TNumber)<STRONG>)</STRONG></SPAN></P></BODY></HTML> Sun, 15 Oct 2017 09:42:36 GMT https://community.qlik.com/t5/QlikView/TableBox/m-p/1451718#M809711 Anil_Babu_Samineni 2017-10-15T09:42:36Z