Fill Listbox with selected Values

[#1]

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

[qlikmsg4u]

Write this condition in list box expression

=If(Field2 = 'PC',Field1)

[sunny_talwar]

Use a Expression for your listbox.

=If(Field2 = 'PC', Field1)

[sunny_talwar · Accepted solution]

Or you can also try this:

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

[#5]

Thanks Sunny. It solved my query.

[sunny_talwar]

Awesome

I am glad I was able to help.

Best,

Sunny