Expression list box selection

Leo2 — Wed, 25 Nov 2020 16:16:04 GMT

Dear community!

I've got kind of such data model:

Person,Type,Event

Person1,1,Event1

Person2,1,Event1

Person1,2,Null

In front end I've got 2 list boxes. The first one is 'Event'. The second is with the expression =if(Type=2,Person)

Any ideas how to connect Event and Person fields? So technically I need field Person to get selected (regardless of Type) when the corresponding value selected in the expression list box (=if(Type=2,Person)). And vice versa - if a field selected in Event list box I'd like to see corresponding values highlighted in expression list box. Could anyone help please?

Re: Expression list box selection

richard_chilvers — Wed, 03 Jul 2019 15:34:13 GMT

I'm not entirely sure what your requirement is.

However, in my experience, list boxes which use an experssion are not ideal.

I would suggest you try creating a new field which is populated from existing data but only for records you want to appear in that list box.

HTH

topic Expression list box selection in QlikView

Expression list box selection

Re: Expression list box selection