I have a straight table with dimension as Account# and two expressions as sum(account#) and count(account#).
Requirement is to show only top 5 values among all values. Can anybody help me to get only top 5 values against available dimension??
Hope got my question.
did you try dimension limit option???
I can go for that but i have Qlikview 10 in my system since it does not have dimensions limit option.
Is there any way to get the output?
then instead of that, you can use rank function.
This is an example of the Rank() function that will give you the top 5 products according to their sales
Use this as a calculated dimension
rank(sum(Sales)) >= 1 AND rank(sum(Sales)) <= 5,
Retrieving data ...