

{"id":43347,"date":"2018-11-28T10:48:19","date_gmt":"2018-11-28T05:18:19","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=43347"},"modified":"2018-11-24T17:49:27","modified_gmt":"2018-11-24T12:19:27","slug":"qlik-sense-ranking-fucntions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/","title":{"rendered":"Qlik Sense Ranking Functions &#8211; Rank and HRank Function"},"content":{"rendered":"<h2><span style=\"font-weight: 400\">1. Objective<\/span><\/h2>\n<p><span style=\"font-weight: 400\">In our last <a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-tutorial\/\"><strong>Qlik Sense Tutorial<\/strong><\/a>, we discussed <strong>Qlik Sense inter-record functions<\/strong>. Today, we will see Qlik Sense Ranking Functions. Moreover, we will see the use of ranking functions in the chart expressions. These Qlik Sense Ranking Functions are used to rank the row value comparing them with the other values in other rows of the table. Such evaluations are important in conducting a comparative analysis of values.<\/span><\/p>\n<div id=\"attachment_43374\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-43374\" class=\"size-full wp-image-43374\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg\" alt=\"Qlik Sense Ranking Functions - Rank and HRank Function\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-43374\" class=\"wp-caption-text\">Qlik Sense Ranking Functions &#8211; Rank and HRank Function<\/p><\/div>\n<p>So, let&#8217;s start the Qlik Sense Ranking Functions tutorial.<\/p>\n<h2>2. Qlik Sense Ranking Functions<\/h2>\n<h3><span style=\"font-weight: 400\">i. Rank() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The rank() function is used to rank the values in a dimension contained in rows. Values in each row are evaluated and compared with values in the other rows within the same dimension or field. So, after the comparison of values in the rows, the rows or corresponding values are ranked on the basis of how big or small the value is as compared to other values. For example, 100 will be ranked 1<\/span><span style=\"font-weight: 400\">st<\/span><span style=\"font-weight: 400\"> and 95 will be ranked 2<\/span><span style=\"font-weight: 400\">nd <\/span><span style=\"font-weight: 400\">and so on. This function returns a value in dual format i.e. in both text and numeric representation.<\/span><\/p>\n<p><strong>Recommended Reading &#8211; <a href=\"https:\/\/data-flair.training\/blogs\/treemap-visualization\/\">Qlik Sense Treemap Visualization<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Rank([TOTAL] expr[, mode[, fmt]])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">expr<\/span><span style=\"font-weight: 400\"> is the dimension or field whose rows or values you want to sort and rank. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Mode<\/span><span style=\"font-weight: 400\"> sets the number representation of the rank returned by the function. You can set this parameter in several ways such as, <\/span><\/p>\n<p><span style=\"font-weight: 400\">0<\/span><span style=\"font-weight: 400\"> which is the default value and assigns a rank to values depending on which side of the middle value they fall on. Basically, if a value falls on the lower side of the middle value then it returns the lowest rank number. And if the value falls on the higher side of the middle value then the function returns the highest rank value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Other values can also be set like <\/span><span style=\"font-weight: 400\">1<\/span><span style=\"font-weight: 400\"> (lowest rank), <\/span><span style=\"font-weight: 400\">2<\/span><span style=\"font-weight: 400\"> (average rank), <\/span><span style=\"font-weight: 400\">3<\/span><span style=\"font-weight: 400\"> (highest rank on all rows) and <\/span><span style=\"font-weight: 400\">4<\/span><span style=\"font-weight: 400\"> (for lowest rank on the first row then one rank incremented for each new value).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Fmt<\/span><span style=\"font-weight: 400\"> sets the text representation of the rank returned by the function. Several values can be set for this parameter like, <\/span><span style=\"font-weight: 400\">0<\/span><span style=\"font-weight: 400\"> which is the default value signifying a range of low value- high value. <\/span><span style=\"font-weight: 400\">1<\/span><span style=\"font-weight: 400\"> for low value on all rows and <\/span><span style=\"font-weight: 400\">2<\/span><span style=\"font-weight: 400\"> for low value on the first row then blank on all the other. <\/span><\/p>\n<p><span style=\"font-weight: 400\">The <\/span><span style=\"font-weight: 400\">TOTAL<\/span><span style=\"font-weight: 400\"> prefix or qualifier if used evaluates all the columns or dimensions of a table and included only those values in evaluation which are the same as the value it is evaluating in the current row. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For instance, we have a data record with fields like Customer and Sales. The rows in the fields have sales values for respective customers. Using the rank function Rank(Sales) we are going to create a measure field in the table which will be ranking of sales values either sorted on Customer or on Sales. <\/span><\/p>\n<p><span style=\"font-weight: 400\">So, as can be seen in the table given below, the values are sorted on the basis of Customer and so all the values corresponding to Benedict will be evaluated and ranked first. The 1<\/span><span style=\"font-weight: 400\">st<\/span><span style=\"font-weight: 400\"> rank is given to the highest value, 88. The ranks descend with the decrease in the value. So, after evaluation of Benedict\u2019s values is complete, then Ethan is taken up for evaluation. The lowest value associate to Ethan is 12 and hence, the lowest rank 10 is given to it.<\/span><\/p>\n<p><strong>You must read &#8211;<\/strong> <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-pie-chart\/\">Qlik Sense Pie Chart<\/a><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Customer<\/b><\/td>\n<td><b>Sales<\/b><\/td>\n<td><b>Rank(Sales)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">12<\/span><\/td>\n<td><span style=\"font-weight: 400\">9<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">28<\/span><\/td>\n<td><span style=\"font-weight: 400\">7<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">45<\/span><\/td>\n<td><span style=\"font-weight: 400\">6<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">58<\/span><\/td>\n<td><span style=\"font-weight: 400\">5<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">60<\/span><\/td>\n<td><span style=\"font-weight: 400\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">65<\/span><\/td>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">70<\/span><\/td>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">88<\/span><\/td>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">12<\/span><\/td>\n<td><span style=\"font-weight: 400\">10<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">If, the table is sorted on Sales, then for any sales value which is same for two customers, the rank would be 1-2 and for those values for which the sales value is unique, the rank is 1. <\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Customer<\/b><\/td>\n<td><b>Sales<\/b><\/td>\n<td><b>Rank(Sales)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">12<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">12<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">25<\/span><\/td>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">34<\/span><\/td>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">45<\/span><\/td>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">48<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">48<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">56<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-3<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Joshua<\/span><\/td>\n<td><span style=\"font-weight: 400\">56<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-3<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Mathew<\/span><\/td>\n<td><span style=\"font-weight: 400\">56<\/span><\/td>\n<td><span style=\"font-weight: 400\">1-3<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">As you can see, when a sales value, say, 12, is common between two customers Benedict and Ethan, then the rank is given as 1-2. And when the sales value 56 is which is common between three customers, Benedict, Joshua, and Ethan, then rank is 1-3.<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mathematical-functions\/\"><strong>Do you know about Qlik Sense Mathematical Functions<\/strong><\/a><\/p>\n<h3><span style=\"font-weight: 400\">ii. HRank() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The HRank() function is a function exclusively used for pivot tables and returns NULL if used in any other visualization. This function evaluates a value given in a row of a column in a pivot table and ranks it according to the values within the same row segment in other columns. So, the result will be rank of the currently evaluated value amongst the entire row segments (i.e. evaluating values of a row horizontally). <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">HRank([ TOTAL ] expr [ , mode [, fmt ] ])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">expr<\/span><span style=\"font-weight: 400\"> is the dimension or field whose rows or values you want to sort and rank. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Mode<\/span><span style=\"font-weight: 400\"> sets the number representation of the rank returned by the function. You can set this parameter in several ways such as, <\/span><\/p>\n<p><span style=\"font-weight: 400\">0<\/span><span style=\"font-weight: 400\"> which is the default value and assigns a rank to values depending on which side of the middle value they fall on. If a value falls on the lower side of the middle value then it returns the lowest rank number. And if the value falls on the higher side of the middle value then the function returns the highest rank value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Other values can also be set like <\/span><span style=\"font-weight: 400\">1<\/span><span style=\"font-weight: 400\"> (lowest rank), <\/span><span style=\"font-weight: 400\">2<\/span><span style=\"font-weight: 400\"> (average rank), <\/span><span style=\"font-weight: 400\">3<\/span><span style=\"font-weight: 400\"> (highest rank on all rows) and <\/span><span style=\"font-weight: 400\">4<\/span><span style=\"font-weight: 400\"> (for lowest rank on the first row then one rank incremented for each new value).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Fmt<\/span><span style=\"font-weight: 400\"> sets the text representation of the rank returned by the function. Several values can be set for this parameter like, <\/span><span style=\"font-weight: 400\">0<\/span><span style=\"font-weight: 400\"> which is the default value signifying a range of low value- high value. <\/span><span style=\"font-weight: 400\">1<\/span><span style=\"font-weight: 400\"> for low value on all rows and <\/span><span style=\"font-weight: 400\">2<\/span><span style=\"font-weight: 400\"> for low value on the first row then blank on all the other. <\/span><\/p>\n<p><span style=\"font-weight: 400\">So, the <\/span><span style=\"font-weight: 400\">TOTAL<\/span><span style=\"font-weight: 400\"> prefix or qualifier if used evaluates all the columns or dimensions of a table and included only those values in evaluation which are the same as the value it is evaluating in the current row. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For example, if we have sales values of different customers, we can rank them on the basis of their performance (total sales are done).<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Customer<\/b><\/td>\n<td><b>Year<\/b><\/td>\n<td><b>Sales<\/b><\/td>\n<td><b>Hrank(Sales)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">2017<\/span><\/td>\n<td><span style=\"font-weight: 400\">$28,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">2017<\/span><\/td>\n<td><span style=\"font-weight: 400\">$20,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Joshua<\/span><\/td>\n<td><span style=\"font-weight: 400\">2017<\/span><\/td>\n<td><span style=\"font-weight: 400\">$36,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Mathew<\/span><\/td>\n<td><span style=\"font-weight: 400\">2017<\/span><\/td>\n<td><span style=\"font-weight: 400\">$45,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Benedict<\/span><\/td>\n<td><span style=\"font-weight: 400\">2018<\/span><\/td>\n<td><span style=\"font-weight: 400\">$26,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Ethan<\/span><\/td>\n<td><span style=\"font-weight: 400\">2018<\/span><\/td>\n<td><span style=\"font-weight: 400\">$29,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Joshua<\/span><\/td>\n<td><span style=\"font-weight: 400\">2018<\/span><\/td>\n<td><span style=\"font-weight: 400\">$32,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Mathew<\/span><\/td>\n<td><span style=\"font-weight: 400\">2018<\/span><\/td>\n<td><span style=\"font-weight: 400\">$35,000<\/span><\/td>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">We have made the four customer names in vertical order (like in a crosstable) but in the pivot table, all four were part of the same row, occurring horizontally.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\">Let&#8217;s revise Qlik Sense Table Functions<\/a><\/strong><\/p>\n<p>So, this was all in Qlik Sense Ranking Functions. Hope you like our explanation.<\/p>\n<h2><span style=\"font-weight: 400\">3. Conclusion <\/span><\/h2>\n<p><span style=\"font-weight: 400\">Hence, we saw all the Qlik Sense Ranking Functions. Thus, these were two of the most important rank functions used in Qlik Sense for ranking values either in rows or columns. You can regulate how the functions will work by defining certain parameters in the functions. These functions are only used in the chart expressions and not in the data load script.<\/span><\/p>\n<p>Still, if you have any query regarding Qlik Sense ranking Functions, ask in the comment tab.<\/p>\n<p><strong>See also &#8211;\u00a0<\/strong><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-app\/\">Create Applications in Qlik Sense\u00a0<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/www.qlik.com\/us\/products\/qlik-sense\"><strong>Reference for Qlik Sense<\/strong><\/a><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1641,&quot;href&quot;:&quot;https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250910054814\\\/https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 14:59:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-12 19:36:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-16 00:14:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-19 05:16:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 07:28:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:15:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 02:13:23&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 05:49:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 07:22:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 08:15:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 13:51:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 16:21:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 02:44:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:03:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:06:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-28 12:37:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 00:15:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 05:47:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 12:47:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-10 15:45:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-13 17:01:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-16 17:50:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-20 06:42:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-23 09:55:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 10:25:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-01 16:39:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-05 05:06:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-08 11:22:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-11 13:38:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-14 19:24:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-18 01:36:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-21 23:13:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 01:59:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 13:02:13&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-01 13:05:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 14:23:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-07 17:56:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-10 21:58:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-14 04:26:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-17 06:08:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-20 07:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-23 09:28:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-27 07:37:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-30 08:39:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 07:49:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-07 09:05:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-10 12:55:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-13 15:31:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:04:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 03:24:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 05:12:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 09:09:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-01 06:19:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-04 09:38:09&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-07 13:53:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-10 23:30:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-14 12:40:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-17 13:15:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-20 15:32:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-23 15:36:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-27 02:26:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-30 05:49:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-03 06:52:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-06 08:01:28&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-09 09:19:08&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-09 09:19:08&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense inter-record functions. Today, we will see Qlik Sense Ranking Functions. Moreover, we will see the use of ranking functions in the chart&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":43374,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17750,17747,17749,17748],"class_list":["post-43347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-hrank-fucntion","tag-qlik-sense-ranking-fucntions","tag-rank-function","tag-ranking-fucntions-in-qlik-sense"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Qlik Sense Ranking Functions - Rank and HRank Function - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Ranking Fucntions, Rank function in Qlik Sense, HRank functions in Qlik Sense, syntax, Exanmple of Ranking Functionsin Qlik Sense\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Ranking Functions - Rank and HRank Function - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Ranking Fucntions, Rank function in Qlik Sense, HRank functions in Qlik Sense, syntax, Exanmple of Ranking Functionsin Qlik Sense\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-28T05:18:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Ranking Functions - Rank and HRank Function - DataFlair","description":"Qlik Sense Ranking Fucntions, Rank function in Qlik Sense, HRank functions in Qlik Sense, syntax, Exanmple of Ranking Functionsin Qlik Sense","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Ranking Functions - Rank and HRank Function - DataFlair","og_description":"Qlik Sense Ranking Fucntions, Rank function in Qlik Sense, HRank functions in Qlik Sense, syntax, Exanmple of Ranking Functionsin Qlik Sense","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-28T05:18:19+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Ranking Functions &#8211; Rank and HRank Function","datePublished":"2018-11-28T05:18:19+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/"},"wordCount":1192,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg","keywords":["HRank Fucntion","Qlik Sense ranking Fucntions","Rank function","Ranking Fucntions in Qlik sense"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/","name":"Qlik Sense Ranking Functions - Rank and HRank Function - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg","datePublished":"2018-11-28T05:18:19+00:00","description":"Qlik Sense Ranking Fucntions, Rank function in Qlik Sense, HRank functions in Qlik Sense, syntax, Exanmple of Ranking Functionsin Qlik Sense","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Ranking-Functions-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Ranking Functions - Rank and HRank Function"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-ranking-fucntions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Ranking Functions &#8211; Rank and HRank Function"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/43347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=43347"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/43347\/revisions"}],"predecessor-version":[{"id":43500,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/43347\/revisions\/43500"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/43374"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=43347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=43347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=43347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}