Remove search item in list box

[#1]

Hi,

I am new to Qlikview and I have created a List Box, where the field name is called closedby.  In this field called closedby, holds all the usernames who have closed issues on a database.  The issue I have is that in this list box there are 10 usernames (as they are the people who have closed calls in our group).  Yet some of these people have either left or are in different groups)  Is it possible that we can remove some of the names. 

I am unable to do this in my load script, as I need to first bring through NULL Values and other usernames may need to be entered depending on who works in the group at the time.

E.G.

adamsv

barryc

choudryb

Donalda

Fitzgeraldg

hillc

jonest

smithf

kayt

younga

From all the usernames above, I want to only keep adamsv, barryc and choudryb.  However in the next two weeks a thomasc could be employeed and therefore when they close a call I would want to choose weather to exclude them or not.

[Nicole-Smith · Accepted solution]

Use an expression in the list box:

if(closedby = 'adamsv' OR closedby = 'barryc' OR closedby = 'choudryb' OR closedby = 'thomasc', closedby, NULL())

[#3]

Hi,

That worked perfectly.  However unfortunately one of the usernames (EG: barryc), was entered as uppercase on the database (therefore shows as BARRYC).  Is there a way which we can amend the expression to ignore the case.

[#4]

if(UPPER(closedby) = 'ADAMSV' OR UPPER(closedby)= 'BARRYC' OR UPPER(closedby)= 'CHOUDRYB' OR UPPER(closedby) = 'THOMASC', UPPER(closedby), NULL())

[MayilVahanan]

Hi

     Try like this,

     =If(MixMatch(closedby,'Adamsv','Barryc','choudryb','thomasc', closedby,null())

     Hope it helps

[Nicole-Smith]

The easiest way to do this would be by using 'like':

if(closedby like 'adamsv' OR closedby like 'barryc' OR closedby like 'choudryb' OR closedby like 'thomasc', closedby, NULL())

This will ignore case.