https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740557#M506322 <P>Count( total &lt;Dept&gt; Ename)</P> Wed, 02 Sep 2020 09:38:00 GMT tresB 2020-09-02T09:38:00Z https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740554#M506321 <P>I have this load script</P><P>MyTable:<BR />LOAD * INLINE [<BR />Ename,Egender,Dept<BR />John,M,10<BR />Hank,N,10<BR />Jill,F,20<BR />Frank,M,20<BR />Joan,F,20<BR />Chris,M,30<BR />];</P><P>&nbsp;</P><P>This results in this straight table&nbsp;</P><P>Ename Egender&nbsp; Dept<BR />Chris&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30<BR />Frank&nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20<BR />Hank&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10<BR />Jill&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20<BR />Joan&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20<BR />John&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>I would like an extra column emp_count_in_dept_with_current_selection with the number of employees in each department&nbsp; in the current selection of my data so</P><P>the desired result would be</P><P>Ename Egender&nbsp; Dept&nbsp; emp_count_in_dept_with_current_selection<BR />Chris&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp;1<BR />Frank&nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; 3<BR />Hank&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 2<BR />Jill&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; 3<BR />Joan&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; 3<BR />Anna&nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp;2</P><P>And when I select F in the straight table I want</P><P>Ename Egender&nbsp; Dept&nbsp; emp_count_in_dept<BR />Jill&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; 2<BR />Joan&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; 2<BR />Anna&nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp;1</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:02:18 GMT https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740554#M506321 frescopozzo 2024-11-16T00:02:18Z https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740557#M506322 <P>Count( total &lt;Dept&gt; Ename)</P> Wed, 02 Sep 2020 09:38:00 GMT https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740557#M506322 tresB 2020-09-02T09:38:00Z https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740559#M506323 <P>Thank you very much!</P> Wed, 02 Sep 2020 09:43:44 GMT https://community.qlik.com/t5/QlikView/Show-count-in-straight-table/m-p/1740559#M506323 frescopozzo 2020-09-02T09:43:44Z