Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Contributor II

Connectred list box

Dear all,

is it possible to connect two listbox ?

Choosing a value into the first one, I would have the same value into the second:

For example I could choose October in the first listbox and the second one should have the same month.

Thanks for youe help

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Connectred list box

See attached example. See the actions on the OnSelect trigger of Field Prod1 to see how this is done.


talk is cheap, supply exceeds demand
3 Replies
Luminary
Luminary

Re: Connectred list box

Depends - are you talking about two different fields which contain the same month? Like Sales_Year & Revenues_Year?

Then I suggest working with triggers. Choose 'Select Field', put in the name of your second listbox/field and in the selection box:
='=sum({<[Listbox2_fieldname]=[Listbox1_fieldname]>}1)'

Don't forget to include the same trigger 'On Change' if necessary.

Let me know if this helps you.

MVP & Luminary
MVP & Luminary

Re: Connectred list box

See attached example. See the actions on the OnSelect trigger of Field Prod1 to see how this is done.


talk is cheap, supply exceeds demand
bibopipo
Contributor II

Re: Connectred list box

Thanks !!!