12 Replies Latest reply: Apr 26, 2017 9:19 AM by omar bensalem

# How to limit the number of point showing on Scatter plot

Dear Sir and Madam,

Creating a scatter plot, want to have 1. Avg(AvgDataUppload_m) as Y axis

and 3.     Phone name as the dimension of the point.

but want to limit only showing top 20 phone name based on (count(SubID))

Could you please teach me how to do that?

Tried but did not make it.

Thank you so much!

• ###### Re: How to limit the number of point showing on Scatter plot

Hi Celine,

Look at the option in the following image:

Regards,
H

• ###### Re: How to limit the number of point showing on Scatter plot

Thank you, Munoz,

I think maybe I did not mention clearly, I am using Qliksense desktop.

could you also teach me how to use the qanliksese to limited the number _

Did not see the windows before

Thank you!

• ###### Re: How to limit the number of point showing on Scatter plot

Hi Celine

try this expression as calculated dimension:

if(aggr(rank(Sum(Your Field)), YourField) <= 20, YourField, Null())

if(aggr(rank(Avg(Your Field)), YourField) <= 20, YourField, Null())

and dont forget to supress the zero-values

and as expression: (count(SubID))

i hope that helps

Beck

• ###### Re: How to limit the number of point showing on Scatter plot

Hi Beck,

Thank you!

I think it works now, using

=if(aggr(rank(count(SubID)), Phone) <= 20, Phone, Null())

in the Data--->Dimention ---> feild  place

but what do you mean ''supress the zero-values' ?

There is a grey doubt in the middle of the graph. Do you mean that?  in the attachment

• ###### Re: How to limit the number of point showing on Scatter plot

Hi Celine,

i mean : Show null Values, but if it does work, then you dont need to do it

• ###### Re: How to limit the number of point showing on Scatter plot

try to deselect: Show null values

• ###### Re: How to limit the number of point showing on Scatter plot

Have you used the limitation setting on the dimension = 20 excluding others?

• ###### Re: How to limit the number of point showing on Scatter plot

Can you share a sample app?

I'll show you how to do that

• ###### Re: How to limit the number of point showing on Scatter plot

sure ! But do not know how to attach an app here.....any suggestion?

• ###### Re: How to limit the number of point showing on Scatter plot

click on this:

• ###### Re: How to limit the number of point showing on Scatter plot

here it is.

several questions here.

1. the limitation of the # of phone name in the second sheet  ---seems work now using agg function but still there is a grey dout in the middle I do not know what is that?

2. Could I use 'dimension' but not  'measure' for Scatter chart for X, Y axis?

3. In the first sheet, there is the horizontal bar chart, if I want to color it by using the sum(avgRevn...) ---the rank is use the sum(SubID)

I tried to use the function in the color area but it does not wok!

Sorry for the trouble and thank you so much for helping me out!

• ###### Re: How to limit the number of point showing on Scatter plot

1) You have Null dimensions, you can eliminate them by unchecking this :

2) You can, check this:  (check the 3rd sheet)

3) You can:

See the attached app