Qlik Sense Slider - Showing 'Others'

[CBRZ]

Hello,

Within my app, I am using the slider  to limit down the number of top customers you see within a Bar Chart.

I am able to get the slider to work and show the correct amount of Customers within the Chart but I can't get the chart to show "Others".

I've tried just about everything and completely lost.

My variable is vCust and below is my formula used.

sum({<[Customer]={'=Rank(Sum([Revenue (USD)]))<=$(vCust)'}>}[Revenue (USD)])

Any way I can show "Others"?

Thanks,

Cory

[Lisa_P]

Try using the Limitation feature in the Dimension properties.
Dimension = Customer
Measure = Sum([Revenue (USD)])
Under Data in your Bar Chart, in the Customer Dimension, Limitation, in the expression editor enter $(vCust) and make sure Show Others is ticked/selected

[CBRZ]

Thank you very much for your assistance, but I have an additional part to this.

The bar chart has two dimensions to this, the Customer with the Y-Axis showing Year.

When I limit down the Dimension to vCust it gives a bunch of random Customers throughout the chart showing some Customers in one year and then not the other.  As of right now, our target year in which I want the top customers, lands in year 2024.

Is there anyway I can rank them in 2024 and then keep the same customers consistent throughout the bar chart?