topic Equivalent of PercentRank function in QlikView https://community.qlik.com/t5/QlikView/Equivalent-of-PercentRank-function/m-p/352430#M130766 <HTML><HEAD></HEAD><BODY><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">Hello.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">Does anybody know which is the equivalent QlikView function of <STRONG style="mso-bidi-font-weight: normal;">PERCENTRANK</STRONG> from Excel?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">PERCENTRANK(<STRONG>array</STRONG>,<STRONG>x</STRONG>,significance) returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">Thank you very much.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P></BODY></HTML> Tue, 15 May 2012 16:23:34 GMT 2012-05-15T16:23:34Z Equivalent of PercentRank function https://community.qlik.com/t5/QlikView/Equivalent-of-PercentRank-function/m-p/352430#M130766 <HTML><HEAD></HEAD><BODY><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">Hello.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">Does anybody know which is the equivalent QlikView function of <STRONG style="mso-bidi-font-weight: normal;">PERCENTRANK</STRONG> from Excel?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">PERCENTRANK(<STRONG>array</STRONG>,<STRONG>x</STRONG>,significance) returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal" style="margin: 0cm 0cm 10pt;"><SPAN style=": ; line-height: 115%; color: #000000; font-size: 12pt; Times New Roman&amp;quot: ; mso-ansi-language: EN-US; font-family: &amp;quot; serif&amp;quot: ; ,&amp;quot: ;">Thank you very much.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P></BODY></HTML> Tue, 15 May 2012 16:23:34 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-PercentRank-function/m-p/352430#M130766 2012-05-15T16:23:34Z Re: Equivalent of PercentRank function https://community.qlik.com/t5/QlikView/Equivalent-of-PercentRank-function/m-p/352431#M130767 <HTML><HEAD></HEAD><BODY><P>I am also trying to find it</P></BODY></HTML> Tue, 18 Nov 2014 08:28:36 GMT https://community.qlik.com/t5/QlikView/Equivalent-of-PercentRank-function/m-p/352431#M130767 2014-11-18T08:28:36Z