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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentile Calculation

Hello,

I need to calculate the percentile of a customer sales against the other customers sales.

I don't know the formula or function that let me do it. Could anybody help me?

Thanks in advance.

3 Replies
swuehl
MVP
MVP

I assume you have a chart with dimension Customer, and that you want to compare his sales to the total sales (all customers).

=sum(SalesField) / sum( TOTAL SalesField)

[replace SalesField with the appropriate field name]

If you want, you can set the number representation to percentage in numbers tab.

Anonymous
Not applicable
Author

Try with:

sum({<Costumer={'CostumerThatYouWant'}>}SalesField) / sum(total sales field)

That compares a specific costumer against the rest of costumers, that is what I understood. And how said swuehl, you can set in numbers tab.

Regards.

Anonymous
Not applicable
Author

Hi,

   Can you please send your example calculation in excel with example data.

regards