Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

going up a level

I have a list sorted by a category with all of the hours associated with that category like this...

category x     20

category y     100

category z      75

I want to create a measure that's the percentage of the whole, so

category/(total sum of all the categories).

how do i go up a level in my formula to get the total sum of all the categories since it's already aggregated by category?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Have a look at the TOTAL argument of the sum() function.

Here is the Help entry for sum()  that explains the TOTAL argument.

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFunction...

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Have a look at the TOTAL argument of the sum() function.

Here is the Help entry for sum()  that explains the TOTAL argument.

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFunction...

Anonymous
Not applicable
Author

Thank you!