Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Celine,
Look at the option in the following image:
Regards,
H
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!
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
Can you share a sample app?
I'll show you how to do that
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
Hi Celine,
i mean : Show null Values, but if it does work, then you dont need to do it
sure ! But do not know how to attach an app here.....any suggestion?
try to deselect: Show null values
Have you used the limitation setting on the dimension = 20 excluding others?