topic Re: Percentile Calculation in QlikView

Percentile Calculation

Mon, 04 Feb 2013 16:37:08 GMT

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.

swuehl — Mon, 04 Feb 2013 16:54:36 GMT

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 — Mon, 04 Feb 2013 18:00:38 GMT

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 — Mon, 04 Feb 2013 18:47:22 GMT

Hi,

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

regards