How to get past NOT, in the GetFieldSelections

[pernillet]

As a part of my expession I have used

if( SubStringCount(GetFieldSelections(Month),'Jan')....

My problem is, when I chose more than half of my months instead of returning jan, feb, mar ...(the selected) then the sting return NOT(Aug, sep,)

So if I aske if the substringcount includes January, and I have selcted everything else but January, then the expression will still tel me, that January is a selcted value.

Is there an easy way to correct this?

Best

Pernille 

[Gysbert_Wassenaar]

Have you tried increasing the number of items that GetFieldSelections returns?

getfieldselections ( Month, ',' , 12 )

[jonathandienst · Accepted solution]

Pernille

You could also try something like this:

If(Left(GetFieldSelections(Month), 3) = 'NOT',

          If(SubStringCount(GetFieldSelections(Month),'Jan') = 0,

                    ... Does not contain Jan in NOT form ...

          )

          If(SubStringCount(GetFieldSelections(Month),'Jan') = 0,

                    ... Contains Jan in normal form ...

          )

)

Hope that helps

Jonathan

[pernillet]

It dit not do any changes

[pernillet]

A lot of if's, but usefull

[Gysbert_Wassenaar]

Weird, works fine for me in QV10.

[pernillet]

I'm also i QV10