# App Development

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor III

## Set analysis / Calculation

Hi All,

I have a table

I need help calculating the percentage distribution.

Thank you

Labels (1)
• ### General Question

1 Solution

Accepted Solutions
MVP

This should work for you:
SUM([# of Staff])/SUM(TOTAL [# of Staff])

The TOTAL keyword tells Qlik to ignore the dimensions on your chart.  If there are dimensions you don't want to ignore, you can put those between <> in a comma separated list.

4 Replies
MVP

This should work for you:
SUM([# of Staff])/SUM(TOTAL [# of Staff])

The TOTAL keyword tells Qlik to ignore the dimensions on your chart.  If there are dimensions you don't want to ignore, you can put those between <> in a comma separated list.

Partner - Specialist

Hi,

In some of viz, you can use "Relative numbers" modifier in your measure (https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/Table/tabl...)

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
Contributor III
Author

Thank Ms. Smith... Sincerely!

Worked like a charm; I appreciate your kinder!

Contributor III
Author

Thank you for the input, will read the reference.

Thanks Again!

Tags
Community Browser