Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

100% on Pie Chart for Top 10 Members of a Dimension

Hi,

Maybe some might have already posted this question sorry for re posting since i didn't get the required answer from other discussions .

I want to display the Top 10 Members in a pie chart in % and their total should be equal to the 100%

My dimension is country and measure is

"sum(Sales_Gross)/Sum(Total Sales_Gross)"

Please suggest me !!!..

I tried formulas like "=if(Aggr(sum(Sales_Gross)/Sum(Total Sales_Gross),country) <= 10, country)" as a calculated dimension and my measure is sum(Sales_Gross)/Sum(Total Sales_Gross)

Please guide me how can i achieve it , i am unchecking the "Others option" too

Thanks for your Time !!!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

You can get by changing your object dimension and expression as below

Dimension

country

Expression

SUM({<country= {"=Rank(SUM(Sales_Gross))<=10"}>}Sales_Gross)

/

SUM(TOTAL {<country= {"=Rank(SUM(Sales_Gross))<=10"}>}Sales_Gross)

View solution in original post

6 Replies
MK_QSL
MVP
MVP

You can get by changing your object dimension and expression as below

Dimension

country

Expression

SUM({<country= {"=Rank(SUM(Sales_Gross))<=10"}>}Sales_Gross)

/

SUM(TOTAL {<country= {"=Rank(SUM(Sales_Gross))<=10"}>}Sales_Gross)

Not applicable
Author

Hi,

This is quite simple and without any formula possible. You only have to click on the Dimension Limits tab and check "Show only" and choose "Largest 10" and uncheck "Show Others"

Then click on the "Expressions" tab and check "Relative" and "Values on Data Points"

The result should be a pie chart showing you the top 10 of your dimension with their total of 100%

Regards,

Claus

cjohnson
Partner - Creator II
Partner - Creator II

Try using the "Relative" button under Expressions:

Image6.png

Using this and setting Dimension Limits to 10 (and unchecking "Show Others") should give you the correct result:

Image7.png

Does this give you what you are looking for?

Not applicable
Author

Hi Reinhard,

Thanks for your time !! . Yup i have changed my expression to as you what you have suggested !!! Your answer is really Helpful !!

Not applicable
Author

Hi Johnson,

Thanks for your time !! . Yup i have changed the expression to the relative !!! Your answer is really Helpful !!

I am really Thankful

Not applicable
Author

Thanks Manish !! It is helpful but will it effect the performance ?