(ORG-6064)
Sample OPJ to download to try:Column Filter.opj
| Table of Contents | ||||
|---|---|---|---|---|
|
...
- Import \Samples\Statistics\Automobile.dat
- Set up a filter on Make column to select only Make=Honda
- CTRL-select the Make, Power and Engine Displacement columns, then right click and select Copy Columns to... and click OK
- Optionally drag the new sheet that is created, to a separate book.
- 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.
- 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.
Row index i support in condition (ORG-7975)
...
to reduce the data to show rows 5, 10, 15....
System Variable to control Text Filter Display (ORG-7805)
...
- @tfl – Max length of text filter label. The first string and last string are always shown. If more than it, ... will show.
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.