Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Showing top 5 values

Hi all,

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.

Thanks,

Shailesh

4 Replies
Not applicable

Re: Showing top 5 values

did you try dimension limit option???

Not applicable

Re: Showing top 5 values

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?

Regards,

Shailesh

Not applicable

Re: Showing top 5 values

then instead of that, you can use rank function.

Employee
Employee

Re: Showing top 5 values

Hi Shailesh

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

=aggr(

if(

  rank(sum(Sales)) >= 1 AND rank(sum(Sales)) <= 5,

  Product

  ),

Product

)

Regards

Agis

Community Browser