topic Re: Using a calculated dimension... in QlikView https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395237#M1163229 <HTML><HEAD></HEAD><BODY><P>Please see the attached QV application</P><P></P><P>Reagrds </P><P>Mhatim</P></BODY></HTML> Tue, 09 Oct 2012 15:12:10 GMT 2012-10-09T15:12:10Z Using a calculated dimension... https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395236#M1163228 <HTML><HEAD></HEAD><BODY><P>This is the first question I have posted so hopefully I can make it clear.</P><P></P><P>I have one big table of individual sales, with amongst other things, value of sale and the EmplyeeNo of the person who made the sale.</P><P></P><P>I want to draw a bar-chart that shows the number of employees who sold different amounts.</P><P></P><P>So the dimension of the bar chart would be something like:</P><P></P><P><STRONG>Round to the nearest 100 ( Sum ( [for each EmployeeNo] SalesValue))</STRONG></P><P></P><P>And the expression would be:</P><P></P><P><STRONG>Count (Distinct EmployeeNo)</STRONG></P><P></P><P>ie I want to look at the distribution of total sales per employee.</P><P></P><P>But I can't figure out how to write the dimension. I have made lots of attempts along the lines of </P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style=": ; font-size: 1;"></SPAN></SPAN></P><P>=&nbsp; </P><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">EmployeeNo</SPAN><SPAN style="font-size: 8pt;">&gt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SaleAmount <SPAN style="color: #333333;">)</SPAN></SPAN><SPAN style="color: #333333;"> </SPAN><P></P><P>But they all return errors...</P><P></P><P>Any help would be much appreciated</P><P></P></BODY></HTML> Tue, 09 Oct 2012 14:37:31 GMT https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395236#M1163228 2012-10-09T14:37:31Z Re: Using a calculated dimension... https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395237#M1163229 <HTML><HEAD></HEAD><BODY><P>Please see the attached QV application</P><P></P><P>Reagrds </P><P>Mhatim</P></BODY></HTML> Tue, 09 Oct 2012 15:12:10 GMT https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395237#M1163229 2012-10-09T15:12:10Z Re: Using a calculated dimension... https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395238#M1163230 <HTML><HEAD></HEAD><BODY><P>Sorry but that's not what I was looking for.</P><P></P><P>I know how to have two axes, one on the left and one on the right.</P><P></P><P>I want the rounded sales amount on the <STRONG>x-axis </STRONG>with a bar for each amount (not for each employee) and then the height of the bar to reflect the count of employees</P></BODY></HTML> Tue, 09 Oct 2012 16:01:00 GMT https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395238#M1163230 2012-10-09T16:01:00Z Re: Using a calculated dimension... https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395239#M1163234 <HTML><HEAD></HEAD><BODY><P>Not sure if this helps.</P><P>Please see the attached QV application</P></BODY></HTML> Wed, 10 Oct 2012 10:44:02 GMT https://community.qlik.com/t5/QlikView/Using-a-calculated-dimension/m-p/395239#M1163234 2012-10-10T10:44:02Z