Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question Re: Displaying Revenue from Top 20 Customers in Button

Hi,

I'm currently trying to use a button to show the total Profitability from the Top 20 Customers. I have the current statement, however it is not working. I'm wondering if anyone would have a suggestion.

=sum({<[Customer Name] = {'=Rank(sum(Amount*-1))<=10'}, [Event Fiscal Year] = {'2016'}, [Event Profitability Code]={'019'} >}Amount) * -1 - sum({<[Customer Name] = {'=Rank(sum(Amount*-1))<=10'}, [Event Fiscal Year] = {'2016'}, [Event Profitability Code]={'020', '021'} >}Amount)

Kind Regards,


Antoinette

1 Reply
Not applicable
Author

Sorry, that should read top 10 customers