topic Re: Calculating Percentiles in QlikView https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559228#M208704 <HTML><HEAD></HEAD><BODY><P>Hi Steve,</P><P></P><P>Have you found a solution to the above problem?</P></BODY></HTML> Wed, 05 Feb 2014 11:46:10 GMT 2014-02-05T11:46:10Z Calculating Percentiles https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559227#M208703 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I am hoping to get some help with calculating percentiles. I have a detail data file containing the following items to date level (with many entries per each individual date):</P><P></P><P>Date</P><P>Week number</P><P>Customer</P><P>Modality</P><P>Number of Days Waiting</P><P></P><P>I want to calculate the 90th percentile of the above data set. In order to achieve this I will need summary file of each individual waiting time (by week number) in order from lowest to highest, and then find the single value which has 90% of all values below it. A slider would also be useful here to allow flexibility on selection of percentile calculation.</P><P></P><P>Has anyone any experience of doing this or suggestions on the best way to approach the problem? </P><P></P><P>Cheers,</P><P>Steve.</P></BODY></HTML> Wed, 11 Dec 2013 09:55:53 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559227#M208703 2013-12-11T09:55:53Z Re: Calculating Percentiles https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559228#M208704 <HTML><HEAD></HEAD><BODY><P>Hi Steve,</P><P></P><P>Have you found a solution to the above problem?</P></BODY></HTML> Wed, 05 Feb 2014 11:46:10 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559228#M208704 2014-02-05T11:46:10Z Re: Calculating Percentiles https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559229#M208705 <HTML><HEAD></HEAD><BODY><P>Fractile(aggr(sum([Numbers of Days Waiting], WeekNumber, Customer), 0.9)</P><P></P><P>You can use a variable instead of the harcdoded 0.9.</P><P></P><P>HTH,</P><P>Michael.</P></BODY></HTML> Wed, 05 Feb 2014 11:51:10 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentiles/m-p/559229#M208705 agilos_mla 2014-02-05T11:51:10Z