Qlik Community

Ask a Question

New to QlikView

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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

QV.PNG

1 Solution

Accepted Solutions
Contributor III
Contributor III

I ended up doing this:

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

which gave the percentile of each value.

View solution in original post

4 Replies
MVP
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
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
Contributor III

I ended up doing this:

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

which gave the percentile of each value.

View solution in original post

Contributor
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,