topic Re: Pivot Table Problem in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402144#M1155532 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Use this Expression</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Aggr(Count(Customer),Sales_Group)</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">You will get count of customers accordning to Sales_Group wise.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hope it helps</SPAN></P></BODY></HTML> Mon, 04 Mar 2013 08:58:09 GMT manideep78 2013-03-04T08:58:09Z Pivot Table Problem https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402143#M1155531 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Today I need a help from you.</P><P></P><P>I've a Pivot table named Chart and its property named prop..</P><P></P><P>I want to count customer with respect to Sales Group and I'm using <SPAN style="color: #993300;">=Count(Customer) <SPAN style="color: #000000;">as expression. It shows 36 instead of 4.</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;">Can anyone help me out of this problem?</SPAN></P><P></P><P><SPAN style="color: #000000;">Thanks in advanced.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P></BODY></HTML> Mon, 04 Mar 2013 08:44:42 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402143#M1155531 senpradip007 2013-03-04T08:44:42Z Re: Pivot Table Problem https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402144#M1155532 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Use this Expression</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Aggr(Count(Customer),Sales_Group)</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">You will get count of customers accordning to Sales_Group wise.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hope it helps</SPAN></P></BODY></HTML> Mon, 04 Mar 2013 08:58:09 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402144#M1155532 manideep78 2013-03-04T08:58:09Z Re: Pivot Table Problem https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402145#M1155533 <HTML><HEAD></HEAD><BODY><P>Hi Manideep,</P><P></P><P>Thanks for reply.</P><P></P><P>According to your expression, it calculates the right result when I select only one Sales_Group, it calculates nothing when nothing selected or more than one Sales_Group selected..</P><P></P><P>What can I do?</P></BODY></HTML> Mon, 04 Mar 2013 09:17:59 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Problem/m-p/402145#M1155533 senpradip007 2013-03-04T09:17:59Z