selections in a list box

[qlikmpate0]

I hav ebeen asked to list only two selection out of several in a list box, has anyone done this ie if selection a,b,c,d,e is available, I only want to show a,c and d?

Has anyone done this if yes please can you guide me on how.

[robert_mika · Accepted solution]

List box-->Field-->Expression

=if(match(Staff,'A','B','C'),Staff)

[MK_QSL]

Create a list box by using expression

IF(Match(YourFieldName,'a','c','d'),YourFieldName)

[amit_saini]

Mina,

See attachment and follow the concept in your case.

Thanks,
AS

[buzzy996]

might be i'm wrong here,are u looking for alternatives in list box instituted of showing all?

exmple: at present ur having: a,b,c,d,e

               expecting:a,c,e?

[ashwanin]

Create List box

and in expression add below to see A,C and D .

=if(match([Field] 'A','C','D'),[Field])

[qlikmpate0]

Thanks works perfect