{"id":38986,"date":"2018-11-13T17:31:50","date_gmt":"2018-11-13T12:01:50","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38986"},"modified":"2021-12-07T11:20:22","modified_gmt":"2021-12-07T05:50:22","slug":"qlikview-rank-function","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-rank-function\/","title":{"rendered":"QlikView Rank Function – How to Use Peek & Rangesum Functions"},"content":{"rendered":"

In this QlikView Aggregate Function<\/strong><\/a>, we will learn about three important functions: QlikView Rank function, Peek Function and Rangesum Function.<\/span><\/span> We will learn about each of them in separate sections with elaborate examples using real data.<\/span><\/span><\/p>\n

So, let’s start with QlikView Rank Function.<\/p>\n

\"QlikView<\/a>

QlikView Rank Function – How to Use Peek & Rangesum Functions<\/p><\/div>\n

QlikView Rank Function<\/h3>\n

QlikView Rank function as the name suggests ranks field the expression according to the criteria you set in the code. We will understand this better while we go through our example. Rank function in QlikView basically returns the ranking values in the rows in front of the row expressions. You can analyze your data more efficiently by ranking it.<\/span><\/span><\/p>\n

Do you know various kinds of QlikView Functions?<\/a><\/strong><\/p>\n

How to Apply QlikView Rank Function?<\/h3>\n

Follow the steps to apply QlikView Rank()function in Chart,<\/span><\/span><\/p>\n

1. Step<\/h4>\n

We will load the CSV file Productrecords.csv into the load script.\u00a0<\/span><\/span><\/p>\n

LOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost\r\nFROM\r\n[C:\\Users\\admin\\Desktop\\Dataflair\\productrecord.csv]\r\n\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq)<\/pre>\n
2. Step<\/h4>\n
Reload the script and open CHART sheet object from LAYOUT. In the dialogue box now open, select the STRAIGHT TABLE from the chart types.<\/span><\/span><\/p>\n
\"QlikView<\/a>
Step.2 To Apply QlikView Rank Function<\/p><\/div>\n
Let’s Explore What is QlikView Join Functions?<\/a><\/strong><\/p>\n
3. Step<\/h4>\n
Click on NEXT, now you will have to select a dimension for your chart. We have selected Product_Line and have added it to the Dimensions. Click NEXT.<\/span><\/span><\/p>\n
\"QlikView<\/a>
Step.3 To Apply QlikView Rank Function<\/p><\/div>\n
4. Step<\/h4>\n
Next will appear an Expression tab, where you have to select a RANK function from the FUNCTIONS tab or write it manually on the editor. Enter the expression for applying Rank function to the selected chart dimension. Here, in the expression, we wrote we want the ranking to be done of the sum of the cost of all the products sorted by the product line.<\/span><\/span><\/p>\n
\"QlikView<\/a>
Step.4 To Apply QlikView Rank Function<\/p><\/div>\n
5. Step<\/h4>\n
Click on FINISH.\u00a0<\/span><\/span><\/p>\n
\"QlikView<\/a>
Step.5 To Apply QlikView Rank Function<\/p><\/div>\n
Must Refer –\u00a0Left, Right, Inner Keep Functions<\/a><\/strong><\/p>\n
6. Step<\/h4>\n
You will have a final table displayed on the sheet having all the product lines ranked according to the sum of their sales or cost.\u00a0<\/span><\/span><\/p>\n
\"QlikView<\/a>
Step.6 To Apply QlikView Rank Function<\/p><\/div>\n
You can also use a rank function within aggregate functions like Min, Max. The rank can be mentioned in the statement itself. Like Max (expression, rank), the rank can you mention will be criteria in the output. If you want the highest selling product line and its cost then you put the rank as 1.<\/span><\/span><\/p>\n
LOAD\r\n    Product_Line,\r\n    max(Product_cost,1)\r\nFROM\r\n[C:\\Users\\admin\\Desktop\\Dataflair\\productrecord.csv]\r\n\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nGroup by Product_Line;<\/pre>\n
\"QlikView<\/a><\/p>\n
\"QlikView<\/a>
Step.8 To Apply QlikView Rank Function<\/p><\/div>\n
Here, in the screenshot, as you can see, in front of each product line is the price of the highest sold item.<\/span><\/span><\/p>\n
QlikView Peek Function<\/h3>\n
Through Peek Function in QlikView, you can get the data of one field or column, roll over in the next column for comparative or calculation purposes. For explanatory purposes we have taken a sample data file salesvol.csv. <\/span><\/span><\/p>\n
\"QlikView<\/a>
QlikView Peek\u00a0Function – Sample<\/p><\/div>\n