Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table
I need help calculating the percentage distribution.
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
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...)
Thank Ms. Smith... Sincerely!
Worked like a charm; I appreciate your kinder!
Thank you for the input, will read the reference.