Rank in Qlikview is used for make ranks or represent rank for the given rows weather they calculate in any order by the aggregated Sum or Count of the calculation expression of any metrics. Rank is mainly used with the aggregated functions in this post i explain about the Top N rank findings in the front end.
Step1:- Suppose we have some Sales Representative data in our application and we can loaded into Qlikview file, have a look the data set.
Step2:- Now from this data we are going to find the Top 10 Sales representative performance then we add the calculated dimension
Note:- Here i explain a way with the calculated dimension we have other ways also.
Step3:- And do not forget to select Suppress When value is Null option from options why this selection requires because the above expression only finds the TOP N then others will shown as NULL values for hiding we are used this option.
Step4:- And then select Sales Expression as Sum(Sales)
Take Straight table chart for data representation and add
Dimension:- [Sales Represenative]
Expression :- Rank(Sum(Sales)) for Rank identification
And the final data you get in the straight table with three fields
In my next post i explain how to make the customized top value selection.
- While using Rank we can get easily give good user interface.
- For Top or Worst dimensional limits we can show in the charts.
- Get performance of any metric values in any charts (Bar, Line, Straight, Pivot) charts.