Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Or you can also try this:

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

View solution in original post

5 Replies
qlikmsg4u
Specialist
Specialist

Write this condition in list box expression

=If(Field2 = 'PC',Field1)

Capture.PNG

sunny_talwar

Use a Expression for your listbox.

=If(Field2 = 'PC', Field1)

sunny_talwar

Or you can also try this:

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

Not applicable
Author

Thanks Sunny. It solved my query.

sunny_talwar

Awesome

I am glad I was able to help.

Best,

Sunny