Calculating the percentile

[#1]

Hi,

I have a field salary and values are (20, 30, 23, 54, 68,454,543,2323).

I want to calculate 85th percentile of these values.

Can I know how to make formula in this tool.

Thanks,

[#2]

Hi there,

Try the following expression:

fractile(SalaryField, .85)

Regrads

[#3]

Thanks for the quick response,

May I know how the function is working behind? pls don't mind can you explain me.

Thanks,

[#4]

Sorry, I actually wrote the expression incorrectly,

It should be something like:

fractile(sum(SalaryField),.85)

I dont know the actual implementation of the formula, if you are looking for the concept perhaps searching the web can be more helpful, as far as I understand the fractile divide the universe of data determined by the factor you specify as an argument.

Regards

[johnw]

It appears that Wikipedia wants to call them quantiles, but here's the basic idea:

http://en.wikipedia.org/wiki/Fractile

As for what specific method QlikView uses, I have no idea, though it might be possible to find out by setting up cases designed to produce different results in the different methods. It wouldn't surprise me if it did the same as Excel, simply because many users would believe the result was wrong if it didn't match Excel. In that case, it would be "Linear interpolation of the modes for the order statistics for the uniform distribution on [0,1]. When p = 1, use X(n)." No, I have no idea what that means. I guess my statistics course didn't get that far.

[#6]

I used the updated formula but in the graph nothing is showing "No data to display".

And Can any one explain me how exactly it is being calculated??

Thanks,

[#7]

Hi Experts,

Anybody have any thought on this?

Thanks,