topic top 5 in QlikView

top 5

master_student — Mon, 16 Oct 2017 14:41:12 GMT

Hello Guys,

I need to display in a table, only the top 5 amount recharge, i know how to do it in a graph but not in a table.

Re: top 5

felipedl — Mon, 16 Oct 2017 14:50:45 GMT

Hi Wiem,

In the DImension limit tab (see bellow) there's the option where you mark the top 5.

In this case, the Recharge AMount must be your first expression, so it gets the top 5 for this amount.

Felipe

Re: top 5

imrasyed — Mon, 16 Oct 2017 14:57:59 GMT

Hi,

You can first sort the values based on the expression.

Then In the Presentation Tab check the Max checkbox and give the limit to 5.

Is this the one you are wanting or anything else?

Note: Message edited by Community Moderator to correct spelling and eliminate shorthand. Please use correct spelling and do not use shorthand or slang because this is a global community and many members rely on translation tools to understand and communicate in other languages.

Re: top 5

master_student — Mon, 16 Oct 2017 15:17:24 GMT

i don't have dimensions limits, in my table graph propreties. see bellow :

Re: top 5

krishnacbe — Mon, 16 Oct 2017 15:18:37 GMT

In Pivot table you can set Dimension Limits. Try with Rank() function.

Re: top 5

Anil_Babu_Samineni — Mon, 16 Oct 2017 15:20:55 GMT

Pivot doesn't have dimension limit offer, So you can create like below

=if(aggr(rank(sum(Sales)),[Description offre])<=5,[Description offre])

Re: top 5

its_anandrjs — Mon, 16 Oct 2017 15:26:32 GMT

You can use any straight table chart for display Top 5 and for input value in variable you can use input box or put your default value like 5 or 10