Hiding non-significant rows

If you have added a minimum p value column to a column proportions or column means test, you can hide rows based on the value in this column. This means that you can carry out a test on all the rows in the table and then hide any rows that contain no significant results, as determined by the minimum p value. To do this, you can use the syntax:

Set R = TableDoc.Table1.Rules.AddNew()

R.Type = 0 ' hide

R.Target = 0 ' row

R.CellItemRef = 0 ' if cellitem 0 (counts)

R.Operator = 4 ' is greater than

R.Value = 0.10 ' required significance level

R.ElementRef = "variablename{MinPVal}" ' for MinPVal column

R.IgnoreSpecialElements = False ' hide special elements

R.Type = 0 ' hide

R.Target = 0 ' row

R.CellItemRef = 0 ' if cellitem 0 (counts)

R.Operator = 4 ' is greater than

R.Value = 0.10 ' required significance level

R.ElementRef = "variablename{MinPVal}" ' for MinPVal column

R.IgnoreSpecialElements = False ' hide special elements

This enables you to carry out a test on all the rows in the table and then hide any rows that contain no significant results, as shown by the minimum p value.

See Adding a minimum p value to a table for an example.

See also