topic Re: Exclude certain values in a List Box in QlikView

Exclude certain values in a List Box

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Exclude certain values in a List Box

sergio0592 — Fri, 21 Jul 2017 10:46:45 GMT

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)

Re: Exclude certain values in a List Box

Fri, 21 Jul 2017 10:48:33 GMT

Thank you Jean-Baptiste that worked perfectly!

Re: Exclude certain values in a List Box

Anonymous — Fri, 21 Jul 2017 10:52:42 GMT

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

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

Re: Exclude certain values in a List Box

chinnuchinni — Fri, 21 Jul 2017 12:28:46 GMT

load

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

Re: Exclude certain values in a List Box

chinnuchinni — Fri, 21 Jul 2017 12:38:22 GMT

sorry,

you can use this

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

Re: Exclude certain values in a List Box

evan_kurowski — Fri, 21 Jul 2017 12:47:05 GMT

Here's the set-analysis version:

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