topic Re: Fill Listbox with selected Values in QlikView

Fill Listbox with selected Values

Mon, 14 Sep 2015 10:46:06 GMT

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 — Mon, 14 Sep 2015 11:46:47 GMT

Write this condition in list box expression

=If(Field2 = 'PC',Field1)

sunny_talwar — Mon, 14 Sep 2015 11:46:51 GMT

Use a Expression for your listbox.

=If(Field2 = 'PC', Field1)

sunny_talwar — Mon, 14 Sep 2015 11:49:58 GMT

Or you can also try this:

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

Tue, 15 Sep 2015 04:01:30 GMT

Thanks Sunny. It solved my query.

sunny_talwar — Tue, 15 Sep 2015 04:18:04 GMT

Awesome

I am glad I was able to help.

Best,

Sunny