Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

Dimension Limit issue in Scatter Chart

Hi,

I have a created a scatter chart with 1 dimension and 3 expressions.

I have given Largest 10 values from the Dimension Limit of the chart and also i have checked "Show Others" option.

I am not able to see a bubble in the chart for Others, but Others is present in the legend.

But i want even the Others as a bubble in the chart.

If i click the others from the legend, then it drill downs to the values of the dimension other than largest 10.

But i want a bubble to be shown even for Others in the chart.

How can i achieve this?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Corrected!

=aggr(if(rank(Sum(Volume)) <=10, Name, 'others'), Name)              //working

View solution in original post

6 Replies
Not applicable

i would suggest you add a calculated dimension in this case rather than using Dimension limit.

aggr(if(rank(measure, <dimension>) <=10, dimension), "others')

udaya_kumar
Specialist
Specialist
Author

Hi Ram,

This is the expression which i used

=aggr(if(rank(Volume, Name) <=10, Name), 'others')

It did not work.

tresesco
MVP
MVP

Try like:

=aggr(if(rank(Sum(Volume)) <=10, Name), 'others')

udaya_kumar
Specialist
Specialist
Author

Hi,

I tried that expression, but it is not working.

It is not showing anything.

Please find my file attached.

tresesco
MVP
MVP

Corrected!

=aggr(if(rank(Sum(Volume)) <=10, Name, 'others'), Name)              //working

muniyandi
Creator III
Creator III

Hi Uday,

use this expression in calculated dimension. if(Aggr(rank(Sum(Volume)),Name)<=10,Name,'Others')

Kindly refer my attachment file.