Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

How to calculate percentile?

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

sokkorn_cheav
Honored Contributor

How to calculate percentile?

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

Re: How to calculate percentile?

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.