Discussion board where members can get started with QlikView.
I was able to use Median and If in the same statement and get the function wokring O.K
However I cannot get the function to work with Fractile
Can someone kindly help me write the correct function for a FRACTILE(IF statement
Go to Solution.
fractile(If([Patient Admitted?]=0, [Total Wait]),0.95)/1440
(moving one closing bracket around)
Thank you! Works perfectly
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.