topic Re: Select Value in a list box based on Selection from another one in QlikView

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

alec1982 — Mon, 03 Jun 2013 20:47:23 GMT

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

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

swuehl — Mon, 03 Jun 2013 20:50:28 GMT

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.

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

alec1982 — Mon, 03 Jun 2013 20:56:22 GMT

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

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

alec1982 — Mon, 03 Jun 2013 21:02:30 GMT

Nevermind, I have associated the table using mapping..

thxs for your help.

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

Fri, 24 Jul 2015 14:39:37 GMT

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!

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

alec1982 — Fri, 24 Jul 2015 15:16:13 GMT

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.

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

Wed, 29 Jul 2015 15:57:30 GMT

Many thanks

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

psankepalli — Wed, 30 Sep 2015 02:28:02 GMT

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

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

Anonymous — Thu, 09 Nov 2017 09:09:27 GMT

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