# New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Calculate percentile of specific value

Hi all,

I've a table with 2 columns - id and value. See the screenshot below and attached file.

I'd like to calculate the percentile of each of the values.

For example, value = 1 should have a percentile of 0.3 (or 30%) since out of the 10 available values, the 3 lowest values are 1.

I suppose I'm actually looking for the inverse of fractile().

Does anybody know how to do this?

Thanks,

Assaf

1 Solution

Accepted Solutions
Contributor III

I ended up doing this:

=rank(Total - values,3)/count(Total values)

which gave the percentile of each value.

4 Replies
MVP

Maybe like

=Rangesum(Above(Count(values),0,rowno())) /Count(TOTAL values)

as expression in a chart with dimension values.

Are these the numbers you are looking for?

MVP

Or if you want to get the percentage for a specific selected value:

=Num(Count({<values = {"<=\$(=Only(values))"}>} values) / count( {1} values),'#.00%')

Contributor III

I ended up doing this:

=rank(Total - values,3)/count(Total values)

which gave the percentile of each value.

Contributor

Hello,

I need to calculate the 80th percentile per month for a set of data. do you have an idea how I can do that in a chart expression?

Thank you,