Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
shivika123
Partner - Contributor
Partner - Contributor

how to get top5 and bottom 5 in Straight Chart

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.

 

7 Replies
venkat1
Creator II
Creator II

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

 

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

shivika123
Partner - Contributor
Partner - Contributor
Author

its not working 

venkat1
Creator II
Creator II

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

shivika123
Partner - Contributor
Partner - Contributor
Author

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

venkat1
Creator II
Creator II

sharing your work file might helps me alot

shivika123
Partner - Contributor
Partner - Contributor
Author

i cant share due to security reason

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.