Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

                                                           2. Avg(AvgDataDownload_m) as X axi

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!

12 Replies
hector_munoz
Specialist
Specialist

Hi Celine,

Look at the option in the 26-04-2017 12-02-51.pngfollowing image:

Regards,
H

Not applicable
Author

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!

beck_bakytbek
Master
Master

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

OmarBenSalem

Can you share a sample app?

I'll show you how to do that

Not applicable
Author

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

1.png

beck_bakytbek
Master
Master

Hi Celine,

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

Not applicable
Author

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

beck_bakytbek
Master
Master

try to deselect: Show null values

ogster1974
Partner - Master II
Partner - Master II

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