Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

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

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

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Nevermind, I have associated the table using mapping..

thxs for your help.

View solution in original post

8 Replies
Highlighted
MVP
MVP

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.

Highlighted
Specialist II
Specialist II

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

Highlighted
Specialist II
Specialist II

Nevermind, I have associated the table using mapping..

thxs for your help.

View solution in original post

Highlighted
Not applicable

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!

Highlighted
Specialist II
Specialist II

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.

Highlighted
Not applicable

Many thanks

Highlighted
Partner
Partner

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

Highlighted
Contributor II
Contributor II

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