Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

Thanks.

3 Replies
goldnejea8
Partner - Creator
Partner - Creator

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

Sokkorn
Master
Master

Hi,

Let try below picture:

Untitled.jpg

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

Regards,

Sokkorn

Not applicable
Author

The definition as used in education:

http://www.nwea.org/support/article/1205:

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.