Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table
I need help calculating the percentage distribution.
Thank you
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.
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.
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
Thank Ms. Smith... Sincerely!
Worked like a charm; I appreciate your kinder!
Thank you for the input, will read the reference.
Thanks Again!