Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Fill Listbox with selected Values

Hi Guys,

I want to fill a Listbox with a criteria.

e.g

Field1    Field2

A               PC

B               PC    

C               PC

D               SC

E               SC

F               PC

I want to fill Field1 in listbox where Field2 = PC.

Thanks,

Maksood Alam

1 Solution

Accepted Solutions

Re: Fill Listbox with selected Values

Or you can also try this:

=Aggr(Only({<Field2 = {'PC'}>} Field1), Field1)

5 Replies
Highlighted
qlikmsg4u
Valued Contributor

Re: Fill Listbox with selected Values

Write this condition in list box expression

=If(Field2 = 'PC',Field1)

Capture.PNG

Re: Fill Listbox with selected Values

Use a Expression for your listbox.

=If(Field2 = 'PC', Field1)

Re: Fill Listbox with selected Values

Or you can also try this:

=Aggr(Only({<Field2 = {'PC'}>} Field1), Field1)

Not applicable

Re: Fill Listbox with selected Values

Thanks Sunny. It solved my query.

Re: Fill Listbox with selected Values

Awesome

I am glad I was able to help.

Best,

Sunny