Multivalue column under view selection

HCL Domino Domino Forum
1

I have a view which is categorized using a multivalue date field say Field_X as the 1st column.** Note that all doc other than DocB got a single value Field_X

It somehow looks like:

2008-9-1

       DocA     .....       .....

       DocB     .....       .....**

2008-10-1

       DocB     .....       .....**

       DocC     .....       .....

2008-11-1

       DocD     .....       .....

2008-12-1

       DocE     .....       .....

…

In order to hide past entries in the view,

I modify by adding following selection criteria in the view:

Field_X >= @Today

So I expect all entries under 2008-9-1 will be gone,

but in fact DocB is still showing:

2008-9-1

       DocB     .....       .....

2008-10-1

       DocB     .....       .....

       DocC     .....       .....

2008-11-1

       DocD     .....       .....

2008-12-1

       DocE     .....       .....

…

How can I suppress the display of entry 2008-9-1 in the view

but at the same time retaining the entry 2008-10-1 for DocB

I try to use Hide Formula in the column field but it doesn’t work.

Thanks in advance.

2

Subject: multivalue column under view selection

Think of views as being built in two steps…

Step 1

The selection formula decides which documents should be in the view’s index. Since one of the Field_X dates meet your criteria, document B will be in the view.

Step 2

The column formulas are run on each document in the view. For document B, there are multiple dates, and so each date is now categorized - including any dates that were less than the limit in the selection formula.

The selection formula only pick documents. It cannot control what happens in the column calculations.

3

Subject: RE: multivalue column under view selection

Thanks Graham, I better think of another solution then.