Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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)

View solution in original post

Not applicable
Author

Thanks Sunny. It solved my query.

sunny_talwar

Awesome

I am glad I was able to help.

Best,

Sunny