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

What is the exactly calculation of the fractile function?

Hi everybody! I am crazy with the calculation of the fractile function.

I have this table:

vendedor:

LOAD * INLINE [

vendedor, venta

1, 77

2, 79

3, 90

4, 85

5, 66

6, 100

7,88

8,97

9,100

10,87

11,90

12,92

];

when I do in object text the calculation: =fractile( total venta , 0.3) return the value: 85.6

BUT... what is the exactly calculation of the fractile function?

Because I am not statistical so I had to learn how function the fractile function and in this video:  https://www.youtube.com/watch?v=PDzLETjOlL0

the result is 84.4, different of 85.6 (value returned by Qlikview)

who is wrong? what happens?

Thank you in advance !!!

18 Replies
MK_QSL
MVP
MVP

I will search on this and come back to you next week... I am also puzzled... so would definitely work on this.

Not applicable
Author

Okey, thank you!!!

sunny_talwar

Attached the logic in the Doc file with the qvw for fractile from 5% till 95% in the increments of 5%

Fractile X% = (N * X%) + (1-X%)

Where N = number of observations in your database (12 in your case)

sunny_talwar

Adding the Excel as Document's calculations might look a little messy.

Not applicable
Author

Thank you Sunny T !

I apreciate your work really, such in this topic like in the community.

Thank you so much again!

Regards

Agustin

sunny_talwar

I am glad I was able to help. My next goal is to fix this document -> Fractile() mystery revealed‌ because the OP might have made a small mistake which might continue to confuse people in the future. But to give the credit to the person who posted it, I wouldn't have got anywhere close in determining what is going on without reverse engineering/play around with his document.

Best,

Sunny

MK_QSL
MVP
MVP

Great work Sunny... !!

sunny_talwar

Thanks Manish

Digvijay_Singh

Thanks a lot Sunny! I also needed this for Sense Box Plot verification.!