Set analysis / Calculation

[nicouek]

Hi All,

I have a table

I need help calculating the percentage distribution.

Thank you

[Nicole-Smith · Accepted solution]

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]

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

[nicouek]

Thank Ms. Smith... Sincerely!

Worked like a charm; I appreciate your kinder!

[nicouek]

Thank you for the input, will read the reference.

Thanks Again!