Exclude certain values in a List Box

[#1]

Hi guys,

I'm new to QlikView and been having an issue with something I hope you can help with.  I have a List Box with the below values in it and I want to exclude the options that don't begin with an A (so only C2, P2 and P7 should appear).  I've tried an expression but it seems to duplicate the values.  Can anyone help with this?  Thanks in advance.

New-Classification

A1 - Documentation Required

A2 - Passive

A3 - Active

C2 - Re-active

P2 - Non Reportable

P7 - Reportable

[sergio0592]

Hi,

For exclude what begins with A:

if(WildMatch(New-Classification,'A*')>0,New-Classification)

For exclude what begins with other letter than A:

if(WildMatch(New-Classification,'A*')=0,New-Classification)

[#3]

Thank you Jean-Baptiste that worked perfectly!

[Anonymous]

HI

I the List box expression use this. Hope it helps you

=if(not WildMatch([New-Classification],'A*'),[New-Classification]) 

[chinnuchinni]

load

if ([New-Classification] like 'A*',[New-Classification]) as [New-Classification] from xxx;

[chinnuchinni]

sorry,

you can use this

if([New-Classification] like 'A*','',[New-Classification])as [New-Classification]

[evan_kurowski]

Here's the set-analysis version:

=Aggr(Only({1 <[New-Classification]-={'A*'}>}[New-Classification]),[New-Classification])