topic Percentile calculation for every month in QlikView https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288397#M586252 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P>I have a database, in which I need to calculate the Percentile for every month's end date. I don't know how to do that. Please suggest how to do that?</P><P>Thanks in advance.</P></BODY></HTML> Tue, 19 Jul 2011 02:41:35 GMT amars 2011-07-19T02:41:35Z Percentile calculation for every month https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288397#M586252 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P>I have a database, in which I need to calculate the Percentile for every month's end date. I don't know how to do that. Please suggest how to do that?</P><P>Thanks in advance.</P></BODY></HTML> Tue, 19 Jul 2011 02:41:35 GMT https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288397#M586252 amars 2011-07-19T02:41:35Z Percentile calculation for every month https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288398#M586253 <HTML><HEAD></HEAD><BODY><P> Hi Amar,</P><P></P><P>Calculate day's up to last day of every month. Then apply calculation.</P></BODY></HTML> Tue, 19 Jul 2011 03:53:09 GMT https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288398#M586253 2011-07-19T03:53:09Z Percentile calculation for every month https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288399#M586254 <HTML><HEAD></HEAD><BODY><P> Fractile(Value, 0.95) in a group by clause did the thing.</P><P>Thanks.</P></BODY></HTML> Wed, 20 Jul 2011 01:42:50 GMT https://community.qlik.com/t5/QlikView/Percentile-calculation-for-every-month/m-p/288399#M586254 amars 2011-07-20T01:42:50Z