topic Re: Sales range as chart dimension in App Development https://community.qlik.com/t5/App-Development/Sales-range-as-chart-dimension/m-p/1219858#M23679 <HTML><HEAD></HEAD><BODY><P>May be with a calculated dimension like this</P><P></P><P><STRONG>=Aggr(If(Sum([Sales Record in Mar]) &lt; 100, 'Total Sales &lt; 100', 'Total Sales &gt;= 100'), Salesperson)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156486_Capture.PNG" style="height: 122px; width: 620px;" /></P></BODY></HTML> Thu, 16 Mar 2017 10:10:38 GMT sunny_talwar 2017-03-16T10:10:38Z Sales range as chart dimension https://community.qlik.com/t5/App-Development/Sales-range-as-chart-dimension/m-p/1219857#M23678 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does any know how to script Sales Range as a dimension of a chart to show number of salesperson in each of such range?&nbsp;&nbsp; Thanks.</P><P></P><P></P><P></P><TABLE border="1" class="jiveBorder" height="199" style="border: 1px solid #000000; width: 280px; height: 184px;" width="278"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Salesperson</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales Record in Mar</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">40</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">75</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Expected Result</P><P></P><P>Total Sales &lt; 100&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp;&nbsp;&nbsp; 1 sales person (C)</P><P>Total Sales &gt; 100&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp;&nbsp;&nbsp; 2 sales person (A &amp; B)</P></BODY></HTML> Thu, 16 Mar 2017 09:25:33 GMT https://community.qlik.com/t5/App-Development/Sales-range-as-chart-dimension/m-p/1219857#M23678 Anonymous 2017-03-16T09:25:33Z Re: Sales range as chart dimension https://community.qlik.com/t5/App-Development/Sales-range-as-chart-dimension/m-p/1219858#M23679 <HTML><HEAD></HEAD><BODY><P>May be with a calculated dimension like this</P><P></P><P><STRONG>=Aggr(If(Sum([Sales Record in Mar]) &lt; 100, 'Total Sales &lt; 100', 'Total Sales &gt;= 100'), Salesperson)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156486_Capture.PNG" style="height: 122px; width: 620px;" /></P></BODY></HTML> Thu, 16 Mar 2017 10:10:38 GMT https://community.qlik.com/t5/App-Development/Sales-range-as-chart-dimension/m-p/1219858#M23679 sunny_talwar 2017-03-16T10:10:38Z