topic Re: Showing top 5 values in Qlik Learning Discussions

Showing top 5 values

Wed, 28 Jan 2015 07:06:02 GMT

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

Wed, 28 Jan 2015 07:14:26 GMT

did you try dimension limit option???

Wed, 28 Jan 2015 07:25:18 GMT

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

Wed, 28 Jan 2015 08:27:54 GMT

then instead of that, you can use rank function.

Agis-Kalogiannis — Thu, 29 Jan 2015 11:08:47 GMT

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

)

Regards

Agis