Warning from EVENT serer log file impacting Performance

amit_saini — Fri, 05 Oct 2018 08:06:54 GMT

Hi All,

On daily basis , i can see below warning in my event log file :

Warning :aggregating on 'Reason_Strichprobe'(%Machine_Line_ID) with Cardinal(35), for Object: Document\CH681 in Doc: D:/ACCESSPOINT/production performance report.qvw

and below is the aggr expression from CH681

sum({<Station.Station_Group_Id = {2},Reason_Strichprobe.Acquisition_Status_No = {0} >} Belgium_Def_TankCalc.Tank_Sum)/

(sum(aggr( distinct (((60*60)/sum( Afloop.Cyclus))*sum([Afloop.Aantal koppen]) *

sum( {<Andon.Welded = {'W'}, %Machine_Line_ID-={'105$A3300'}>}[Andon.Working_Hours/Shift]) ) ,%Machine_Line_ID, Reason_Strichprobe.Shift_Desc)))

Any idea if we can change whole expression to Set Analysis???

Regards,

topic Warning from EVENT serer log file impacting Performance in QlikView

Warning from EVENT serer log file impacting Performance