using an express in the list box search (magnifying glass icon)

Wed, 08 Dec 2010 09:40:56 GMT

This should totally be an easy answer, I just can't find it anywhere. Help documentations states "Use an equal sign (=) to search using an expression." referring to the user search (filter) tool found on list boxes (magnifying glass icon). I'm using QlikView 9.0.

Can someone please explain how to do this? The following does not select the value, "USA" after typing it in the search box and pressing enter. ='*USA*'

*USA* should work the same as ='*USA*' right?

Ultimately I'm trying to select everything except USA. So can someone also provide the syntax for using an expression to exclude data as in <>'USA'.

Thanks!

using an express in the list box search (magnifying glass icon)

Tue, 21 Dec 2010 16:29:48 GMT

So yeah, this was an easy answer. I didn't find the direct answer to my question however in QlikView 9 there is an option to make your selection an exclusion. In a list box go to the Caption tab and under Special Icons check Select Possible and/or Select Excluded. This will accomplish the desired task for the above post.

topic using an express in the list box search (magnifying glass icon) in QlikView

using an express in the list box search (magnifying glass icon)

using an express in the list box search (magnifying glass icon)