topic Re: Top 4 with an additional 'other' bar in QlikView

Top 4 with an additional 'other' bar

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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...

Re: Top 4 with an additional 'other' bar

Digvijay_Singh — Mon, 19 Feb 2018 18:39:54 GMT

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

Re: Top 4 with an additional 'other' bar

shilpan — Mon, 19 Feb 2018 19:46:59 GMT

Re: Top 4 with an additional 'other' bar

Anonymous — Mon, 19 Feb 2018 22:48:40 GMT

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