Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nate_eyster
Partner - Contributor II
Partner - Contributor II

Grouping dimensions by ranked measure

All,

I am trying to make a simple bar chart that has one dimension, "Top 10 Sites", which averages the top ten sites by measure (utilization rate), and then have another date point that would include all sites outside the Top 10 by Utilization rate. I would assume it would be an aggr(if(rank(avg))) or something along those lines.. Any input? see visual I'm trying to derive below.

top ten sites.png

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

you are correct

your dimension should be

aggr(if(rank(avg(utilization rate))<=10,'Top 10','Other Sites'),Site)

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

you are correct

your dimension should be

aggr(if(rank(avg(utilization rate))<=10,'Top 10','Other Sites'),Site)

MK_QSL
MVP
MVP

Create a bar chart without dimension

Use below two expressions

SUM({<Site = {"=Rank(Avg(Sales),4)<=10"}>}Sales)

SUM({<Site = {"=Rank(Avg(Sales),4)>10"}>}Sales)

Change Sales field with your respective measure field..