Problem with aggr?

[qlikconsultant]

I have a pivote table that shows the downtime of machines. This table has the 2 dimensions week and downtime cause. I need to calculate a percentage value for the downtime.
Basically the expression is Sum(Downtime)/Total(PlannedTime per week)
I use this formula:

Sum(minutes_downtime)/Sum(aggr(Sum(PlannedTime), Week))

But it does not work properly. I only see results in 1 row.

Thanks for any tips or hints.

[rwunderlich · Accepted solution]

I think you want to use TOTAL rather then Aggr() here. 

Sum(minutes_downtime) / Sum(TOTAL<Week> PlannedTime)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[qlikconsultant]

Thanks.