BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
kuannygoh

Not applicable

Joined:

Oct 21, 2018

How to fix a control chart builder without it auto updating from a row state change

 Hi all , 

I encounter a problem here , code below is being used to filter out the outlier flag of tile count  in a data table steptable and plot a control chart builder.

It works fine , but i encounter problems as this control chart tends to auto update whenever i exclude a new outlier flag. 

Any way to prevent it from auto updating ?

 

	steptable[i] << select all rows;
				steptable[i] << exclude( 0 );
				steptable[i] << select where( :TileCount_OutlierFlag == 1 );
				steptable[i] << exclude;
				steptable[i] << select where( :TileCount_OutlierFlag == 0 );
				For( l = 1, l <= N Items( losscode ), l++,
					If( losscode[l] == "NULL",
						Wait( 1 ),
						LotCountlist << Add(
							losscode[l],
							ob1 = Outline Box( "Control Chart Builder",
								steptable[i] << Control Chart Builder(
						
									Show Control Panel( 0 ),
									Show Capability( 0 ),
									Variables( Subgroup( :Txndate ), Subgroup( :Waferscribenumber, Position( 1 ) ), Y( :Waferrejectsqty ) ),
									Chart( Position( 1 ), Limits( Sigma( "Levey Jennings" ) ) ),
									Chart( Position( 2 ), Limits( Sigma( "Moving Range" ) ) ),
									By( :Lossreasonname ),
									Where( :Lossreasonname == losscode[l] )
							
				
	

								)
							);
							
						)
					)
				);
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: How to fix a control chart builder without it auto updating from a row state change

Here is one way to do it.  Save just the report output for display.  That will keep from it getting updated.

steptable[i] << select all rows;
steptable[i] << exclude( 0 );
steptable[i] << select where( :TileCount_OutlierFlag == 1 );
steptable[i] << exclude;
steptable[i] << select where( :TileCount_OutlierFlag == 0 );
For( l = 1, l <= N Items( losscode ), l++,
	If( losscode[l] == "NULL",
		Wait( 1 ),
		LotCountlist << Add(
			losscode[l],
			ob1 = Outline Box( "Control Chart Builder", 
				
			);
			ccb = steptable[i] << Control Chart Builder(
						
				Show Control Panel( 0 ),
				Show Capability( 0 ),
				Variables(
					Subgroup( :Txndate ),
					Subgroup( :Waferscribenumber, Position( 1 ) ),
					Y( :Waferrejectsqty )
				),
				Chart( Position( 1 ), Limits( Sigma( "Levey Jennings" ) ) ),
				Chart( Position( 2 ), Limits( Sigma( "Moving Range" ) ) ),
				By( :Lossreasonname ),
				Where( :Lossreasonname == losscode[l] )
			);
			ob1 << append( Report( ccb ) );
			ccb << close window;
		)
	)
);
Jim
1 REPLY 1
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: How to fix a control chart builder without it auto updating from a row state change

Here is one way to do it.  Save just the report output for display.  That will keep from it getting updated.

steptable[i] << select all rows;
steptable[i] << exclude( 0 );
steptable[i] << select where( :TileCount_OutlierFlag == 1 );
steptable[i] << exclude;
steptable[i] << select where( :TileCount_OutlierFlag == 0 );
For( l = 1, l <= N Items( losscode ), l++,
	If( losscode[l] == "NULL",
		Wait( 1 ),
		LotCountlist << Add(
			losscode[l],
			ob1 = Outline Box( "Control Chart Builder", 
				
			);
			ccb = steptable[i] << Control Chart Builder(
						
				Show Control Panel( 0 ),
				Show Capability( 0 ),
				Variables(
					Subgroup( :Txndate ),
					Subgroup( :Waferscribenumber, Position( 1 ) ),
					Y( :Waferrejectsqty )
				),
				Chart( Position( 1 ), Limits( Sigma( "Levey Jennings" ) ) ),
				Chart( Position( 2 ), Limits( Sigma( "Moving Range" ) ) ),
				By( :Lossreasonname ),
				Where( :Lossreasonname == losscode[l] )
			);
			ob1 << append( Report( ccb ) );
			ccb << close window;
		)
	)
);
Jim