Top 4 with an additional 'other' bar

[Anonymous]

Hello!   I am new to Qlik and have a question on how to do the following.

Create a bar chart that shows the top 4 customers of the 10 total.   The other customers should be grouped into an 'Others" bar.

So the bar chart would have top customer #1 name and value, customer #2 name and value, customer #3 name and value, customer #4 name and value, and the rest aggregated into an others bar with the total.

I have used If(Rank(Sum(ExtendedPrice)) <=4,  Num(Sum(ExtendedPrice), '###,##0'))     to get the top but I am not sure how to get the "Others" bar.   Do I  create a new expression or can this be included in my expression above...  

[Digvijay_Singh]

You may want to use 'limited' option in properties. See the image below for more details-

[shilpan]

[Anonymous]

Thanks for the quick feedback.   The interface looks different.   I am using the QlikView November 2017 SR2 Version 12.