topic Re: selections in a list box in QlikView

selections in a list box

qlikmpate0 — Thu, 02 Apr 2015 11:34:34 GMT

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.

Re: selections in a list box

robert_mika — Thu, 02 Apr 2015 11:41:53 GMT

List box-->Field-->Expression

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

Re: selections in a list box

MK_QSL — Thu, 02 Apr 2015 11:43:38 GMT

Create a list box by using expression

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

Re: selections in a list box

amit_saini — Thu, 02 Apr 2015 11:49:02 GMT

Mina,

See attachment and follow the concept in your case.

Thanks,
AS

Re: selections in a list box

buzzy996 — Thu, 02 Apr 2015 11:49:33 GMT

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?

Re: selections in a list box

ashwanin — Thu, 02 Apr 2015 11:58:41 GMT

Create List box

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

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

Re: selections in a list box

qlikmpate0 — Thu, 02 Apr 2015 12:17:44 GMT

Thanks works perfect