https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596148#M737568 <P>are you looking for this?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Unbenannt.png" style="width: 366px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14459i562FE3E584501003/image-size/large?v=v2&amp;px=999" role="button" title="Unbenannt.png" alt="Unbenannt.png" /></span></P> Wed, 26 Jun 2019 09:55:29 GMT Frank_Hartmann 2019-06-26T09:55:29Z https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596123#M737566 <P>Hi,</P><P>I need to calculate 80th percentile for the count of sales orders for each month.</P><P>&nbsp;</P><P>Attached is the sample data.</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks..</P> Sat, 16 Nov 2024 20:34:52 GMT https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596123#M737566 krish2459 2024-11-16T20:34:52Z https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596138#M737567 <P>Hi Krish,</P><P>&nbsp;</P><P>what is the result you need in that excel file?</P><P>=Aggr(count distinct(Sales Order),month)</P> Wed, 26 Jun 2019 09:37:48 GMT https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596138#M737567 ramasaisaksoft 2019-06-26T09:37:48Z https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596148#M737568 <P>are you looking for this?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Unbenannt.png" style="width: 366px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14459i562FE3E584501003/image-size/large?v=v2&amp;px=999" role="button" title="Unbenannt.png" alt="Unbenannt.png" /></span></P> Wed, 26 Jun 2019 09:55:29 GMT https://community.qlik.com/t5/QlikView/80th-Percentile-calculation/m-p/1596148#M737568 Frank_Hartmann 2019-06-26T09:55:29Z