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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.