Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Warning from EVENT serer log file impacting Performance

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,

AS

0 Replies