Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

only dsplay most popular reasons

I am looking at number of calls coming in over time and I want to only display on a chart the top 5 reasons for calling in (i.e. the most number of calls for a particular reason) against time. If I have number of calls and reason for calling how would I formulate an expression to do the above?

Thanks

Rosie

1 Solution

Accepted Solutions
Not applicable
Author

chart properties, sort table, select reasons, check expression and numeric value and set both to descending

go to presentation tab, dimension limitation, check max visiblke number and type in 5

View solution in original post

1 Reply
Not applicable
Author

chart properties, sort table, select reasons, check expression and numeric value and set both to descending

go to presentation tab, dimension limitation, check max visiblke number and type in 5