topic Re: Set analysis / Calculation in App Development

Set analysis / Calculation

nicouek — Mon, 08 Aug 2022 15:55:02 GMT

Hi All,

I have a table

I need help calculating the percentage distribution.

Thank you

Re: Set analysis / Calculation

Nicole-Smith — Mon, 08 Aug 2022 15:59:39 GMT

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.

Re: Set analysis / Calculation

Aurelien_Martinez — Mon, 08 Aug 2022 16:07:52 GMT

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/table-properties-panel.htm)

Aurélien

Re: Set analysis / Calculation

nicouek — Mon, 08 Aug 2022 16:09:56 GMT

Thank Ms. Smith... Sincerely!

Worked like a charm; I appreciate your kinder!

Re: Set analysis / Calculation

nicouek — Mon, 08 Aug 2022 16:13:29 GMT

Thank you for the input, will read the reference.

Thanks Again!