Top 5 & Bottom 5 Values

[#1]

Hi Experts,

I want top 5 and bottom 5 customers. How to write the expression

Please help me

Thanks in Advance

[Clever_Anjos]

There´s a function called FirstSortedValue that can do what you need

Bottom customers:

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),1)

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),2)

...

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),5)

Topcustomers:

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),1)

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),2)

...

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),5)

[qlikviewwizard]

Hi Abhi,

Please check my Firstsortedvalue Vs FirstValue Example

[#4]

Hi Clever,

Its not working. I want to display top and bottom 5 customers in Bar chart.

Thanks in Advance

[#5]

depending on what you are trying to accomplish, you may be able to use your standard expression and use Dimension limits tab

[Clever_Anjos]

Sorry, if you need it inside a graphe please use Dimension Limits as akrepistman‌ told

[Clever_Anjos]

It would be easier if you post a sample of your application

[Clever_Anjos · Accepted solution]

Please find attached if fits your needs

[Anonymous]

Hi,

Try this