# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## Pie Chart with a limit of 100 on dimension problem

Hey everyone,

Hope you all are well,

I have a problem that I cannot seem to solve, let's start off with my data I have a table that looks like the following

BRANCH | REP NAME | REP CODE | CUSTOMER NAME | CUSTOMER ACCOUNT | WTD SALES | MTD SALES | YTD SALES | TARGET

Also, I have a calculated field called sales status. this field does the following if a sales have been made to a customer it will become 'Partially Reached' if nothing has been sold to the customer it will become 'Not Sold To' if the salesmen have exceeded his target per the client it will become 'Target Reached'

I want to display this field 'Sales Status' breakdown in a pie chart for the top 100 customers per that sales rep

Please see attached I have this split working with KPI's but I cannot get it to work with a pie chart   the problem is the pie chart keeps on displaying the breakdown of all customers in total and not per 100 per salesrep as i want it. if i do a selection on 100 it works

Labels (2)

• ### pie chart

1 Solution

Accepted Solutions

## Re: Pie Chart with a limit of 100 on dimension problem

How is your measure to show top 100 customers? If you measure is simple like Sum(Measure) you can try

Sum({<Customer = {"=Rank(Sum(Sales))<=100"}>} Measure)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies

## Re: Pie Chart with a limit of 100 on dimension problem

How is your measure to show top 100 customers? If you measure is simple like Sum(Measure) you can try

Sum({<Customer = {"=Rank(Sum(Sales))<=100"}>} Measure)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor

## Re: Pie Chart with a limit of 100 on dimension problem

Hi There

awesome thank you, it works