topic Equivalent of Centile.Exclude Function in QlikView https://community.qlik.com/t5/QlikView/Equivalent-of-Centile-Exclude-Function/m-p/352477#M130793 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: times new roman,times; font-size: 12pt;">Hello.<SPAN lang="EN-US" style="color: black; mso-ansi-language: EN-US;"> </SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: times new roman,times; font-size: 12pt; mso-ansi-language: EN-US;">We would like to use the CENTILE.EXCLUDE function as defined in Excel.</SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN><SPAN lang="EN-US" style="color: black; font-family: times new roman,times; mso-ansi-language: EN-US;">We have already tried the QlikView FRACTILE function but it is similar to CENTILE.INCLUDE function from Excel.</SPAN></SPAN></P><P><SPAN style="font-family: times new roman,times; font-size: 12pt;"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN lang="EN-US" style="color: black; mso-ansi-language: EN-US;"> </SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN><SPAN lang="EN-US" style="color: black; font-family: times new roman,times; mso-ansi-language: EN-US;">Could you please help us to find the QlikView equivalent function of CENTILE.EXCLUDE?</SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P><P><SPAN style="font-family: times new roman,times; font-size: 12pt;"><SPAN lang="EN-US" style="color: black; mso-ansi-language: EN-US;"> </SPAN></SPAN><SPAN style="color: black; font-size: 12pt; mso-ansi-language: EN-US; font-family: times new roman,times;">Thank you.</SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P></BODY></HTML> Tue, 15 May 2012 16:27:40 GMT 2012-05-15T16:27:40Z Equivalent of Centile.Exclude Function https://community.qlik.com/t5/QlikView/Equivalent-of-Centile-Exclude-Function/m-p/352477#M130793 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: times new roman,times; font-size: 12pt;">Hello.<SPAN lang="EN-US" style="color: black; mso-ansi-language: EN-US;"> </SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: times new roman,times; font-size: 12pt; mso-ansi-language: EN-US;">We would like to use the CENTILE.EXCLUDE function as defined in Excel.</SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN><SPAN lang="EN-US" style="color: black; font-family: times new roman,times; mso-ansi-language: EN-US;">We have already tried the QlikView FRACTILE function but it is similar to CENTILE.INCLUDE function from Excel.</SPAN></SPAN></P><P><SPAN style="font-family: times new roman,times; font-size: 12pt;"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN lang="EN-US" style="color: black; mso-ansi-language: EN-US;"> </SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN><SPAN lang="EN-US" style="color: black; font-family: times new roman,times; mso-ansi-language: EN-US;">Could you please help us to find the QlikView equivalent function of CENTILE.EXCLUDE?</SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P><P><SPAN style="font-family: times new roman,times; font-size: 12pt;"><SPAN lang="EN-US" style="color: black; mso-ansi-language: EN-US;"> </SPAN></SPAN><SPAN style="color: black; font-size: 12pt; mso-ansi-language: EN-US; font-family: times new roman,times;">Thank you.</SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;"> </SPAN></P></BODY></HTML> Tue, 15 May 2012 16:27:40 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-Centile-Exclude-Function/m-p/352477#M130793 2012-05-15T16:27:40Z