Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
helen_pip
Contributor II

Fractile and if

Hello

I was able to use Median and If in the same statement and get the function wokring O.K

 

MEDIAN

(IF([adm]=0,[Total]/1440))

However I cannot get the function to work with Fractile

  fractile(If([adm]=0, [Total],0.95)/1440)

Can someone kindly help me write the correct function for a FRACTILE(IF statement

Many Thanks

Helen

1 Solution

Accepted Solutions
MVP
MVP

Re: Fractile and if

Try

  fractile(If([Patient Admitted?]=0, [Total Wait]),0.95)/1440

(moving one closing bracket around)

3 Replies
MVP
MVP

Re: Fractile and if

Try

  fractile(If([Patient Admitted?]=0, [Total Wait]),0.95)/1440

(moving one closing bracket around)

helen_pip
Contributor II

Re: Fractile and if

Thank you!  Works perfectly

Not applicable

Re: Fractile and if

Please help me.

I have exam data of a class of 50 students.

Now I want to calculate the average (and, median) of top 80% students of that class.

How can I do that?
Please help.

Thanks.

Community Browser