how to get top5 and bottom 5 in Straight Chart

[shivika123]

I have a dimension State and created a variable let suppose $(v#Name)

In $(v#Name) is a set expression,according to this variable i want to show top 5 and bottom states value in straight chart.

[venkat1]

=If(Aggr(Rank(Sum(Sales)) <= 5,seller),seller)

=If(Aggr(Rank(Sum(Sales)) >= 5,seller),seller)

[shivika123]

its not working 

[venkat1]

 use this in dimension  =If(Aggr(Rank(Sum(value)) <= 5,state),state) 
measure sum(value)

[shivika123]

alraedy done this its not working no value ar e been displayed 

[venkat1]

sharing your work file might helps me alot

[shivika123]

i cant share due to security reason

[Brett_Bleess]

Just FYI, you can use the Settings\Document Properties\Scrambling tab settings to scramble any confidential fields in the data, that should negate the security concern I would think such that you can post a small version of things.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Document_Proper...

Regards,
Brett