Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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