topic Re: Bar Chart - Grouping Dimension in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400142#M424562 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>Aggr(<SPAN style="color: #ff0000;">Avg</SPAN>(Sales), [Sales Rep])</STRONG></P><P></P><P>Expression</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Count(DISTINCT [Sales Rep])</STRONG></P></BODY></HTML> Wed, 20 Sep 2017 13:44:06 GMT sunny_talwar 2017-09-20T13:44:06Z Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400137#M424557 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a simple bar chart that counts the number of sales by a sales rep.</P><P></P><P>Would it be possible to display the number of users with a certain amount of sales rather than an individual user?</P><P></P><P>er; if the graph shows :</P><P></P><P>User A 25 Sales</P><P>User B 25 Sales</P><P>User C 40 Sales</P><P>User D 40 Sales</P><P>User E 40 Sales</P><P>User F 2 Sales</P><P>User G 10 Sales</P><P></P><P>could it effectively show:</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">40 Sales - 3 Users</SPAN></P><P>25 Sales - 2 Users</P><P>40 Sales - 3 Users</P><P>10 Sales - 1 User</P><P>2 Sales - 1 User</P><P></P><P></P><P>Many thanks,</P><P></P><P>Phil</P></BODY></HTML> Tue, 12 Sep 2017 15:59:09 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400137#M424557 prees959 2017-09-12T15:59:09Z Re: Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400138#M424558 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>Aggr(Sum(Sales), [Sales Rep])</STRONG></P><P></P><P>Expression</P><P><STRONG>Count(DISTINCT [Sales Rep])</STRONG></P></BODY></HTML> Tue, 12 Sep 2017 16:00:28 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400138#M424558 sunny_talwar 2017-09-12T16:00:28Z Re: Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400139#M424559 <HTML><HEAD></HEAD><BODY><P>Perfect Thank you!</P></BODY></HTML> Tue, 12 Sep 2017 17:40:01 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400139#M424559 prees959 2017-09-12T17:40:01Z Re: Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400140#M424560 <HTML><HEAD></HEAD><BODY><P>Hello Phil,</P><P>Can you close the thread Marking Sunny's response correct/helpful. That way other members can benefit from your query. </P><P></P><P>Thanks,<BR />V.</P></BODY></HTML> Tue, 12 Sep 2017 20:21:24 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400140#M424560 vishsaggi 2017-09-12T20:21:24Z Re: Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400141#M424561 <HTML><HEAD></HEAD><BODY><P>Hi I hope you don't mind me asking another question on the back of this one?</P><P></P><P>I would like to show the average number of sales a rep would make? </P><P></P><P>Thanks,</P><P></P><P>Phil,</P></BODY></HTML> Wed, 20 Sep 2017 13:41:39 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400141#M424561 prees959 2017-09-20T13:41:39Z Re: Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400142#M424562 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>Aggr(<SPAN style="color: #ff0000;">Avg</SPAN>(Sales), [Sales Rep])</STRONG></P><P></P><P>Expression</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Count(DISTINCT [Sales Rep])</STRONG></P></BODY></HTML> Wed, 20 Sep 2017 13:44:06 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400142#M424562 sunny_talwar 2017-09-20T13:44:06Z Re: Bar Chart - Grouping Dimension https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400143#M424563 <HTML><HEAD></HEAD><BODY><P>thanks !!</P></BODY></HTML> Thu, 21 Sep 2017 10:45:11 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Grouping-Dimension/m-p/1400143#M424563 prees959 2017-09-21T10:45:11Z