Versions Compared

Old Version 22

changes.mady.by.user Snow Li

Saved on

compared with

New Version 23

changes.mady.by.user Echo Chu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(ORG-6064)

Sample OPJ to download to try:Column Filter.opj


Table of Contents
maxLevel2
minLevel2

Copy Column To and Save Filter Info. in Operation (ORG-6078, ORG-8385)


The Data Filter feature can be used in conjunction with the column copy X-Function to produce multiple graphs from the same source data using different filtering conditions. Selected columns from the source data sheet can be copied to create child sheets where the filter condition stays synchronized with the parent sheet, or is locked to the child sheet. When the source data sheet is updated, all child sheets, associated graphs and analysis results will automatically update using their respective filter conditions. Additionally, the filter condition of a particular child sheet can be pushed back at any time to the parent sheet.

How to:

  1. Import \Samples\Statistics\Automobile.dat
  2. Set up a filter on Make column to select only Make=Honda
  3. CTRL-select the Make, Power and Engine Displacement columns, then right click and select Copy Columns to... and click OK
  4. Optionally drag the new sheet that is created, to a separate book.
  5. Click on the lock in the new sheet and select Worksheet Filters: Lock. Now the filter condition will be locked to this sheet, so any analysis and graphing you perform on this sheet will be based on the locked filter.
  6. You can go back to the raw data sheet and change filter conditions and make other such copy sheets and lock their respective filters, allowing you to compare graphs and results between multiple filter conditions.

Image Modified

Row index i support in condition (ORG-7975)

Conditions in Data Filter tool can use the row index "i", such as:

mod(i,5)=0

to reduce the data to show rows 5, 10, 15....

 

System Variable to control Text Filter Display (ORG-7805)

System variables are added to control the display of text filter conditions. User needs to manually click Refresh button to see updates.

@TFS: 0=Enter, 1=Space (default), 2=Comma, 3=Semicolon

 

 

Control getting missing values for hidden rows (ORG-8396)

Getting or not missing values from hidden rows (except for analysis and plotting) can be controlled by @GMH system variable.