Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-05-31 08:15 AM

Top 1% of Values

Hello,

I have a little problem with a dashboard:

I want calcul 2 Top of a table :

the first is : Count the top 1% of players who makes maximum turnover

The second is: Take the total of top 1% divide bu the numbers of players in Top 1% to calculate the Avg turnover of the top 1%

For this I have a table user and a table with for each user the turnover who he have.

How in qlikview I can do this ? I need to calculate de 1% of users for each month and event.

You have an idea please?

816 Views
0 Likes
0 Replies