Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
V_Mota
Contributor
Contributor

How to limit the number of items in a boxplot?

How to limit the number of items in a boxplot?How to limit the number of items in a boxplot?

I tried to use the following script:

=Aggr(

if(Rank([Volume (Scs)])<=10, Fabricante, 'OUTROS'), Fabricante)=Aggr(
if(Rank([Volume (Scs)])<=10, Fabricante, 'OUTROS'), Fabricante)

But is showing the following message:

V_Mota_0-1750903606205.png

 

That scrip works in every other visualization, except for the boxplot.

Labels (3)
1 Reply
Chanty4u
MVP
MVP

Try this

 Create a master dimension and use this 

=If(Rank(Sum([Volume (Scs)])) <= 10, Fabricante, 'OUTROS')