Expression Results Help

[#1]

Hi Folks

I have an expression as follows:

=if(Index(GetFieldSelections("ColName"),'Dim1') , 1 , 0 )

This is being used to control the conditional show of a column in a straight table, the expression works fine when only a few selections are made, but when many selections are made it doesn't work. This is because the result of GetFieldSelections("ColName") changes from a list of selections to a list of not selected:

EG:

Result 1 = Dim1 , Dim2, V1, V2, V3

But Result 2 Could be = NOT Dim5, Dim6, V4

So, what would be the best way to change the expression so that it works 100% of the time, and I would if possible like to avoid using macros to achieve this.

Any help greatly appreciated.

[#2 · Accepted solution]

Hy,

Try the Maxvalues option in the formula.

It's only when the count gets near or above Maxvalues that QV starts using "NO..." or "ALL".

GetFieldSelections("AA",',',999)

Greetings,

Piet

[#3]

Hello Piet

Thanks very much, exactly what I was looking for.

Cheers,