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

Calculating Percentage on a Bar Chart

Hi!

I'm new user and am building a horizontal bar chart that I would like to show the total number of awards for each award category and the percentage of total awards for each category as a label.  The Category Field is my dimension.

I was honing in the Category field to perform the calculations, but I can't get the percentage to calculate correctly.

I was hoping for some suggestions in calculating the percentage of awards for each category using the attached sample data.

Any help is appreciated!

Thanks!

Pat

1 Solution

Accepted Solutions
ahaahaaha
Partner - Master
Partner - Master

Hi Patrick,

May be like this

Dimension: Category,

Expression: Count(Category)/Count(TOTAL Category)

and on the tab "Number" of chart set the readings in percent.

Regards,

Andrey

View solution in original post

4 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi Patrick,

May be like this

Dimension: Category,

Expression: Count(Category)/Count(TOTAL Category)

and on the tab "Number" of chart set the readings in percent.

Regards,

Andrey

prieper
Master II
Master II

Create another expression with text on Axis and an expression like

COUNT(Award) / COUNT(TOTAL Award)

Which counts the number of awards, subject to Dimensions shown in relation to the total count

Peter

Not applicable
Author

Andrey and Peter -

Thanks so much for your assistance and quick reply!  Your advice worked like a charm!

Much appreciated!

Pat

abdul_mo
Contributor II
Contributor II

thanks alot Andery