Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to calculate percentile?

Hi all,

I have a dimension 'total marks'. it has got total marks scored by a student out of 300.

I want to display the same in percentile.

Can someone suggest me on how I can achieve the same?


3 Replies

How to calculate percentile?

Try checking the option "Show in Percent" on the numbers tab.

Honored Contributor

How to calculate percentile?


Let try below picture:


It is better to understand what you want if you can provide sample data and result you looking for.



Not applicable

Re: How to calculate percentile?

The definition as used in education:


A percentile ranking represents how well a student performs compared to other students in a nationwide norm sample for their grade. A student scoring at the 35th percentile scored as well as, or better than, 35 percent of students in the same grade in the norm group. It also means that 65 percent of the students exceeded this score.

A common mistake is for people to think this means that the student got 35 percent of the items correct. Percentile is not related to the percent of correct answers a student gets on a test.

The percentile is not a good method for measuring growth in students. Students who achieve typical growth will remain at approximately the same percentile score over time.

Please have a look at the fractile function, as mentioned in http://community.qlik.com/message/15054#15054.

Community Browser