Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Factile Function error

Hi All,

I have data something like this.

 

0
0
0
0
0
0
0
0.0017412
0.0267893
0.0302776
0.0325067
0.1604363
0.162742
0.1701797
0.1712399
0.2154379

When I apply fractile function it is giving me below mentioned results:

25th percentile: 0.0325067

50th percentile: 0.162742

75th percentile: 0.1712399

100th percentile:0.2154379

But I doubt whether it is correct. Can someone explain it to me?

Thanks in advance.

Regards,

Rishikesh

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I can't reproduce your results, I do get these

Fractile(VAL, 0.25) = 0

Fractile(VAL, 0.5) = 0.01426525

Fractile(VAL, 0.75)=0.161012725

Fractile(VAL, 1) = 0.2154379

which seems reasonable.

View solution in original post

1 Reply
swuehl
MVP
MVP

I can't reproduce your results, I do get these

Fractile(VAL, 0.25) = 0

Fractile(VAL, 0.5) = 0.01426525

Fractile(VAL, 0.75)=0.161012725

Fractile(VAL, 1) = 0.2154379

which seems reasonable.