topic Re: Count dimension in pivot table in QlikView https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985692#M970436 <HTML><HEAD></HEAD><BODY><P>Like the people before me has mentioned, we would need more details to help you resolve your issue. What is your dimension in the above chart and can you provide the sample data with its expected output?</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 20 Sep 2015 14:49:21 GMT sunny_talwar 2015-09-20T14:49:21Z Count dimension in pivot table https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985689#M970433 <HTML><HEAD></HEAD><BODY><P>Hi all please help me to count the failure student like the requirements in image. and sorry for bad english</P><P>Example: (Pivot Table)</P><P></P><P>Student ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Curriculum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pass/Fail</P><P></P><P>S0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1654<SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fail</SPAN></P><P>S0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C6549&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fail</P><P>S0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C9875&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fail&nbsp;&nbsp; </P><P>S0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C5498&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fail</P><P>S0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C6545&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Fail</SPAN> </P><P>S0003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C5465&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Fail</SPAN></P><P>S0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C2465&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Fail</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>the requirement in picture:</P><P><IMG alt="qlik question.png" class="jive-image image-1" src="/legacyfs/online/99437_qlik question.png" style="height: auto; width: auto;" /></P></BODY></HTML> Sun, 20 Sep 2015 09:39:57 GMT https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985689#M970433 Anonymous 2015-09-20T09:39:57Z Re: Count dimension in pivot table https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985690#M970434 <HTML><HEAD></HEAD><BODY><P>Provide sample data for this!</P></BODY></HTML> Sun, 20 Sep 2015 10:01:14 GMT https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985690#M970434 MK_QSL 2015-09-20T10:01:14Z Re: Count dimension in pivot table https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985691#M970435 <HTML><HEAD></HEAD><BODY><P>Can you explain more, please?</P></BODY></HTML> Sun, 20 Sep 2015 10:49:33 GMT https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985691#M970435 ecolomer 2015-09-20T10:49:33Z Re: Count dimension in pivot table https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985692#M970436 <HTML><HEAD></HEAD><BODY><P>Like the people before me has mentioned, we would need more details to help you resolve your issue. What is your dimension in the above chart and can you provide the sample data with its expected output?</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 20 Sep 2015 14:49:21 GMT https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985692#M970436 sunny_talwar 2015-09-20T14:49:21Z Re: Count dimension in pivot table https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985693#M970437 <HTML><HEAD></HEAD><BODY><P>I think Count() wrapped in an Aggr() should work well for this scenario:</P><P></P><P></P><P><IMG alt="2015-09-20 #2.png" class="jive-image image-1" src="/legacyfs/online/99441_2015-09-20 #2.png" style="height: 231px; width: 620px;" /></P></BODY></HTML> Sun, 20 Sep 2015 15:17:33 GMT https://community.qlik.com/t5/QlikView/Count-dimension-in-pivot-table/m-p/985693#M970437 petter 2015-09-20T15:17:33Z