topic Re: Fractile and if in QlikView

Fractile and if

helen_pip — Tue, 11 Sep 2012 14:43:12 GMT

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

swuehl — Tue, 11 Sep 2012 14:46:44 GMT

Try

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

(moving one closing bracket around)

helen_pip — Tue, 11 Sep 2012 14:50:43 GMT

Thank you! Works perfectly

Sat, 10 Aug 2013 18:24:54 GMT

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.