Aggregated Percentage Calculation

[#1]

I have a table containing two dimensions (week, ressource).

Furthermore I have two key figures (capacity, planned).

Now I need to set up a chart showing the ratio of planned to the capacity.

This means I have to devide sum(planned) through the sum of the capacity for each week.

But thats not correct at all.

The capacity must be the sum of all ressources for each week.

I have tried to use this expression =SUM(AGGR(sum(capacity),WEEK)) and the result looks like this:

The values are correct but the capacity must be shown in all rows.

How can I do this?

[Anonymous]

can you post a sample app.. that way it will be easier to try different things and suggest the working option.

[hic]

See this blog post: http://community.qlik.com/blogs/qlikviewdesignblog

You should do almost the same, but your expression should be

     RangeSum(Above(Sum(planned), 0, Count([VGFRSNAME.Resourcename]))) / Sum(total <CW> capacity)

or something similar.

HIC

[#4 · Accepted solution]

I found the solution on my own. But thanks for your reply Aadil.

Its much easier than I thought.

Just use SUM(TOTAL <[WEEK]> capacity).

The expression will look like than:

=SUM(planned)/(SUM(TOTAL <[week]> capacity))*100