Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
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.
My bad, your right Andrea .
Hey I am getting an error in expression. Error says Aggr takes at least two parameters.
That was really helpful. This thing worked for me. Thanks,
Aggr(if(Rank(Sum(Revenue)) <= 10, Customers, null()),Customers)