Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Dimension Limits on Bubble Charts

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).

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).

How can I reduce the data displayed based on the quantity ordered?

1 Reply
Highlighted
Champion III
Champion III

Scott,

Try to replace your dimension, whatever it is, with a calculated dimension where you use rank function, i.e. where rank(<your 3rd expression>) <=10.

Regards,

Michael