Hi, Fuan lik Chan.
See if this help.
Access the properties of straight table:
Totals on Last Row in Totals;
Numeric Value Ascending.
Hope this helps!
In your Expression's tab, go to the section that says "total mode" and change the radio button to the 3rd option and make it "sum of rows". in the presentation's tab change the "totals" label to "top 3"
in your dimension limit's tab - check the box that says show totals - and give it an appropriate label: "grand total"
that will restrict the "top 3" calculation to only calculate on what is displayed in the table. be sure to deselect show others in your dimension limits tab.
top3.qvw 146.8 K
correct me if i am wrong but I believe qlikview has its own ranking system and because the same expression can be done over multiple dimensions it will always say that the dimension calculation is a subset of the expression calculation (even with only 1 dimension) and therefore always put the dimension total closer to the data set
i.e: Grand total is a dimension calculation and top3 is an expression calculation (limited to the dimension restrictions places by saying sum of rows) therefore grand total will be on the bottom when totals are above and grand total will be at the top when the totals are below thus ensuring it is closer to the data when displaying.
in your case it is not optimal but it has its purpose when looking at badly labeled data models.
Sorry to disappoint but hopefully you can live with it.
p.s. if you use my solution - please make thumbs up or make correct answer