Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr function help

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

0 Replies