topic Problem with aggr? in App Development

Problem with aggr?

qlikconsultant — Mon, 19 May 2025 11:44:33 GMT

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.

Re: Problem with aggr?

rwunderlich — Mon, 19 May 2025 14:13:00 GMT

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

Re: Problem with aggr?

qlikconsultant — Mon, 26 May 2025 12:48:11 GMT

Thanks.