Aggr function help

Thu, 27 Aug 2015 05:52:22 GMT

Hi all,

am using Aggr function first time.

I have done one one expression

but I need to join two aggr functions into one

Currently am working for OEE report .

Please check the below expressions

(Sum(aggr((sum({<FiscalYear={$(=max(FiscalYear))},ReworkOrder -={09,10},Type={'Machine'},//[16 Loss Group Head] ={'',''}

Date={">=$(=monthstart(max({<Flag={'Actual'}>}Date)))<=$(=max({<Flag={'Actual'}>}Date))"}>}Ptime3)),Order,Conf_Key,Date,WorkCentre,Shift)))

I want to add below expression into one

(Sum(aggr((sum({<FiscalYear={$(=max(FiscalYear))},ReworkOrder -={09,10},Type={'Machine'},[16 Loss Group Head] ={'Minor Stoppages','Reduced Speed'},

Date={">=$(=monthstart(max({<Flag={'Actual'}>}Date)))<=$(=max({<Flag={'Actual'}>}Date))"}>}Duration_DURA.ZPDWTDT)),Order,Conf_Key,Date,WorkCentre,Shift)))

Please help me..

Thanks

Surender

topic Aggr function help in QlikView

Aggr function help