topic Re: List Box Properties in QlikView

List Box Properties

hkg_qlik — Wed, 02 May 2012 18:57:01 GMT

Hi,

Can anyone help me with List Box. I want to hide few status available in a particular field name. Is it possible to hide.

For eg: Registration Status

Accepted

Committed

Dropped

Now i want user only to see Two status in the list box under Registration Status: Accepted & Committed.

Regards,

jonathandienst — Wed, 02 May 2012 19:28:29 GMT

Use the following expression (select Expression at the bottom of the field name list) to the list box:

If([Registration Status] <> 'Dropped', [Registration Status])

Regards

Jonathan

Wed, 02 May 2012 19:34:14 GMT

Try using an expression:

if(match([Registration Status],'Accepted','Committed'),[Registration Status])

Edit: Above answer works too. Thats what happens when I open severa tabs and it takes me an answer to look at the question.