Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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)

View solution in original post

2 Replies
Highlighted
Partner
Partner

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)

View solution in original post

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