topic Re: Like and Not Like Equivalent in QlikView

Like and Not Like Equivalent

Tue, 17 Mar 2015 14:43:59 GMT

I have records that have ITEM_NBRs like the following:

AVSCC00000

G5R85

G5889

LOKDA0002

I want to remove these from a list box.

In Microsoft Access I would use something like the following

Not Like "AVS*" And Not Like "FB*" And Not Like "G*" And Not Like "LOK*"

What statement could I use in QlikView?

Thanks for your help in advance.

Re: Like and Not Like Equivalent

rwunderlich — Wed, 18 Mar 2015 02:32:59 GMT

The trick is you;ll need an aggr(). You could use the Not LIke And syntax but wildmatch() may be easier. You can code it as a if() or a Set expression.

=aggr(if(NOT WildMatch(ITEM_NBR,'AVS*','FB*'),ITEM_NBR), ITEM_NBR)

=aggr(Only({<ITEM_NBR={"=NOT WildMatch(Country,'AVS*','FB*')"}>} ITEM_NBR), ITEM_NBR)

-Rob

Re: Like and Not Like Equivalent

Wed, 18 Mar 2015 12:40:19 GMT

Thank you for your help.

I entered =aggr(if(NOT WildMatch(ITEM_NBR,'AVS*','FB*'),ITEM_NBR), ITEM_NBR) in the Expressions/Definition section of my list box and Enabled it to no avail.

I am very new to Qlikview as I just finished a week long training session last week. Any help is appreciated.