topic Dimension Limits on Bubble Charts in QlikView https://community.qlik.com/t5/QlikView/Dimension-Limits-on-Bubble-Charts/m-p/653002#M1058504 <HTML><HEAD></HEAD><BODY><P>I have a bubble chart showing the count of times a product was ordered on the X-axis, the count of unique customers that purchased the product on the Y-axis, and the sum of the order quantity on the Z-Axis (bubble size). </P><P></P><P>Now I want to limit the data displayed to the top 10 values by quantity ordered (Z-Axis or 3rd Expression), but the Dimension Limits tab only uses the first expression (X-axis ~ count of times ordered). </P><P></P><P>How can I reduce the data displayed based on the quantity ordered?</P></BODY></HTML> Thu, 02 Oct 2014 20:44:19 GMT hobanwashburne 2014-10-02T20:44:19Z Dimension Limits on Bubble Charts https://community.qlik.com/t5/QlikView/Dimension-Limits-on-Bubble-Charts/m-p/653002#M1058504 <HTML><HEAD></HEAD><BODY><P>I have a bubble chart showing the count of times a product was ordered on the X-axis, the count of unique customers that purchased the product on the Y-axis, and the sum of the order quantity on the Z-Axis (bubble size). </P><P></P><P>Now I want to limit the data displayed to the top 10 values by quantity ordered (Z-Axis or 3rd Expression), but the Dimension Limits tab only uses the first expression (X-axis ~ count of times ordered). </P><P></P><P>How can I reduce the data displayed based on the quantity ordered?</P></BODY></HTML> Thu, 02 Oct 2014 20:44:19 GMT https://community.qlik.com/t5/QlikView/Dimension-Limits-on-Bubble-Charts/m-p/653002#M1058504 hobanwashburne 2014-10-02T20:44:19Z Re: Dimension Limits on Bubble Charts https://community.qlik.com/t5/QlikView/Dimension-Limits-on-Bubble-Charts/m-p/653003#M1058505 <HTML><HEAD></HEAD><BODY><P>Scott,</P><P></P><P>Try to replace your dimension, whatever it is, with a calculated dimension where you use rank function, i.e. where rank(&lt;your 3rd expression&gt;) &lt;=10.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Fri, 03 Oct 2014 01:45:18 GMT https://community.qlik.com/t5/QlikView/Dimension-Limits-on-Bubble-Charts/m-p/653003#M1058505 Anonymous 2014-10-03T01:45:18Z