topic Re: Remove search item in list box in QlikView

Remove search item in list box

Mon, 06 Aug 2012 13:21:07 GMT

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.

Re: Remove search item in list box

Nicole-Smith — Mon, 06 Aug 2012 13:22:50 GMT

Use an expression in the list box:

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

Re: Remove search item in list box

Mon, 06 Aug 2012 13:36:05 GMT

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.

Re: Remove search item in list box

Mon, 06 Aug 2012 14:00:23 GMT

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

Re: Remove search item in list box

MayilVahanan — Mon, 06 Aug 2012 14:06:21 GMT

Try like this,

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

Hope it helps

Re: Remove search item in list box

Nicole-Smith — Mon, 06 Aug 2012 15:03:15 GMT

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.