Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikmpate0
Contributor

selections in a list box

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.

Tags (1)
1 Solution

Accepted Solutions

Re: selections in a list box

List box-->Field-->Expression

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

02-Apr-15 12-43-55 PM.jpg

02-Apr-15 12-43-11 PM.jpg

6 Replies

Re: selections in a list box

List box-->Field-->Expression

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

02-Apr-15 12-43-55 PM.jpg

02-Apr-15 12-43-11 PM.jpg

Re: selections in a list box

Create a list box by using expression

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

amit_saini
Honored Contributor III

Re: selections in a list box

Mina,

See attachment and follow the concept in your case.

Thanks,
AS

buzzy996
Honored Contributor II

Re: selections in a list box

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
Valued Contributor

Re: selections in a list box

Create List box

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

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

qlikmpate0
Contributor

Re: selections in a list box

Thanks works perfect

Community Browser