Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hbatavia
Contributor
Contributor

How to limit top 10 by a measure not used in chart

I created a bar chart on Customers by Profit but I want to limit the chart to just show top 10 customers by Revenue (which is not used in chart). Any idea how to do that?

Thanks in advance.

1 Solution

Accepted Solutions
agigliotti
Partner
Partner

I think you should create a calculated dimension.

ex. Aggr( if( Rank(Sum(Revenue)) <= 10, Customer, null() ) )  and uncheck "Include null values" checkbox under dimension.

View solution in original post

4 Replies
agigliotti
Partner
Partner

I think you should create a calculated dimension.

ex. Aggr( if( Rank(Sum(Revenue)) <= 10, Customer, null() ) )  and uncheck "Include null values" checkbox under dimension.

View solution in original post

qv_testing
Specialist II
Specialist II

My bad, your right Andrea .

hbatavia
Contributor
Contributor

Hey I am getting an error in expression. Error says Aggr takes at least two parameters.

hbatavia
Contributor
Contributor

That was really helpful. This thing worked for me. Thanks,

Aggr(if(Rank(Sum(Revenue)) <= 10, Customers, null()),Customers)