Set Analysis (Does Not Contain)

[Qvmaster2019]

Hi,

Does anybody know how to do this using set analysis.

I am trying to count records where a certain field does not start with 'Q:'

I have something like this but seems not working

count({<left(Name,2)-={'Q:'}>} Id)

[Anonymous · Accepted solution]

I don't think you can change the left hand side of a test like that. How about ...

count({<Name-={'Q:*'}>} Id)

The wildcard * should act the same way as if you did a search from a list boxes caption.

Jonathan

[#3]

Hello,

Try this :

count(if( not wildmatch(Name, 'Q:*' ), Id))

or

count({< Name-= {"Q:*"} >}Id)

Amand Dupretz

[Qvmaster2019]

jonbroughavone, it shows zero even if i changed the <> operator.

[Qvmaster2019]

Amand Dupretz, also shows me zero and shows no dimensions