Select Value in a list box based on Selection from another one

[alec1982]

Hi Guys,

I have couple of list boxes and I need the following scenario..

When a user select a value in a list box 1 a value in list box 2 is selected..

Any help is appreciated!

Thxs,

Alec

[swuehl]

If standard associative logic won't make it, you can use a OnSelect field event trigger (from document properties - triggers) with a Select - Select in field action.

[alec1982]

Hi,

Thank you for the reply. but that will not associate the two fields together, right? they are coming from different data set and I would like the user to be able to associate them .. so when he/ she select a avalue in the first field then avalue in the second field will be selected.

Thxs,

Alec

[alec1982 · Accepted solution]

Nevermind, I have associated the table using mapping..

thxs for your help.

[#5]

Select Value in a list box based on Selection from another one‌

Would you be able to explain how you did the mapping?

I'm trying to do a similar thing I think. When you select one field in the list box (1st dataset), I'd like it then to automatically make the selection in the list box in another sheet of the same field (but from a different data set), so that the user doesn't have to make the selection twice themslelves.. The list of fields is the same in both datasets, so the mapping could perhaps work!

[alec1982]

in my case the two list boxes are art of the same table so I created a column to combine both of them and then did subfield on both listboxes.

[#7]

Many thanks

[psankepalli]

Hi Ewa,

You can achieve with the on select Field Event trigger. Please see the attached document.

Document Properties -> Triggers -> Field Event Triggers -> Select Filed (Desc1) -> On Select Add Action-> Actions New window opens -> Click Add button -> Selection Select in Field ,

    Enter Filed as Desc 2

    Searching String : ='=sum({<[Desc 2]=[Desc 1]>}1)'

I hope this will solve your issue.

Thanks

KR

[Anonymous]

Hi Prasanna,

I had similar requirement and your solution worked effectively . Thank you so much . Could you please elaborate in detail on how the above mentioned search string works .

i.e Searching String : ='=sum({<[Desc 2]=[Desc 1]>}1)'

I am a fresher to Qlikview and I will be eager to understand the mechanism behind this logic .

Thanks in advance!!

Regards,

Rajalakshmi