# Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New 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.

Tags (1)
1 Solution

Accepted Solutions
Honored Contributor II

## Re: Grouping dimensions by ranked measure

hi

you are correct

your dimension should be

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

2 Replies
Honored Contributor II

## Re: Grouping dimensions by ranked measure

hi

you are correct

your dimension should be

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

MVP

## Re: Grouping dimensions by ranked measure

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..

Community Browser