topic Re: How to calculate the counts in Pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244102#M394735 <HTML><HEAD></HEAD><BODY><P>Till how many ID's you have to exclude?</P></BODY></HTML> Mon, 20 Mar 2017 15:38:17 GMT Anil_Babu_Samineni 2017-03-20T15:38:17Z How to calculate the counts in Pivot table https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244099#M394732 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a&nbsp; below requirement .i have to calculate count of ID's ,in two different expressions.</P><P>1)First expression should have only Count of ID's ,whose ST value is only Nursing Unit Reporting group.</P><P>2)Second expression must have count of ID's ,those having the ST values Nursing Unit Reporting Group and Quality of Food Service .in this expression, those Id's having only quality of Food service are not required.</P><P><IMG alt="Examp.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156873_Examp.PNG" style="height: 384px; width: 620px;" /></P></BODY></HTML> Mon, 20 Mar 2017 15:27:08 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244099#M394732 2017-03-20T15:27:08Z Re: How to calculate the counts in Pivot table https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244100#M394733 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>=Cound({&lt;ST = {'Nursing Unit Reporting Group'}&gt;}ID)</STRONG></P><P></P><P><STRONG>=Count({&lt;ST = {'Nursing Unit Reporting Group','Quality of Food Service'}, ID-= {'5','28'}&gt;}ID)</STRONG></P></BODY></HTML> Mon, 20 Mar 2017 15:31:48 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244100#M394733 Anil_Babu_Samineni 2017-03-20T15:31:48Z Re: How to calculate the counts in Pivot table https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244101#M394734 <HTML><HEAD></HEAD><BODY><P>I have&nbsp; so many iDs are there,which is having only ST as Quality of Food Service.</P><P>should i mention all id's&nbsp; manually in the&nbsp; expression?</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Count({&lt;ST = {'Nursing Unit Reporting Group','Quality of Food Service'}, ID-= {'5','28'}&gt;}ID)</STRONG></P></BODY></HTML> Mon, 20 Mar 2017 15:36:11 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244101#M394734 2017-03-20T15:36:11Z Re: How to calculate the counts in Pivot table https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244102#M394735 <HTML><HEAD></HEAD><BODY><P>Till how many ID's you have to exclude?</P></BODY></HTML> Mon, 20 Mar 2017 15:38:17 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244102#M394735 Anil_Babu_Samineni 2017-03-20T15:38:17Z Re: How to calculate the counts in Pivot table https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244103#M394736 <HTML><HEAD></HEAD><BODY><P>Currently i have 3000 ids to exclude.it may change also, if i load full data.</P></BODY></HTML> Mon, 20 Mar 2017 15:44:50 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244103#M394736 2017-03-20T15:44:50Z Re: How to calculate the counts in Pivot table https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244104#M394737 <HTML><HEAD></HEAD><BODY><P>I am out of memory, <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ <A href="https://community.qlik.com/qlik-users/61824">marcowedel</A>‌</P></BODY></HTML> Mon, 20 Mar 2017 16:10:24 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-counts-in-Pivot-table/m-p/1244104#M394737 Anil_Babu_Samineni 2017-03-20T16:10:24Z