topic Re: Set Analysis (Does Not Contain) in QlikView

Set Analysis (Does Not Contain)

Qvmaster2019 — Thu, 03 Jan 2013 12:57:49 GMT

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 — Thu, 03 Jan 2013 13:04:22 GMT

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

Thu, 03 Jan 2013 13:06:18 GMT

Hello,

Try this :

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

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

Amand Dupretz

Qvmaster2019 — Thu, 03 Jan 2013 13:11:08 GMT

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

Qvmaster2019 — Thu, 03 Jan 2013 13:13:37 GMT

Amand Dupretz, also shows me zero and shows no dimensions