Skip to main content

App Development

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

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

Set analysis / Calculation

Hi All,

I have a table

I need help calculating the percentage distribution.

nicouek_0-1659974076064.png

Thank you

Labels (1)
1 Solution

Accepted Solutions
Nicole-Smith

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.

View solution in original post

4 Replies
Nicole-Smith

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.

Aurelien_Martinez
Partner - Specialist
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...)

amartinez35_0-1659974855899.png

 

Aurélien

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

Thank Ms. Smith... Sincerely!

Worked like a charm; I appreciate your kinder!

 

nicouek
Contributor III
Contributor III
Author

Thank you for the input, will read the reference.

Thanks Again!