topic Use trigger to select values in one field based on values in another in QlikView

Use trigger to select values in one field based on values in another

Thu, 17 May 2012 13:36:57 GMT

Hi community, You guys are great and I really appreciate all your help! If I have a field that has 12 values say A, B, C and woul like each of those to trigger the selection of a different value say 1, 2, 3, how would I do that? I think I'd need to use a trigger. I'd like something like selecting A in field ONE to select 1 in field TWO and selecting B in field ONE to select 2 in field TWO.

Re: Use trigger to select values in one field based on values in another

oscar_ortiz — Thu, 17 May 2012 15:45:37 GMT

Here's a way of doing this using triggers.

Good luck

Oscar

Use trigger to select values in one field based on values in another

Thu, 17 May 2012 16:13:46 GMT

What a community! Thanks a bunch Oscar!

Use trigger to select values in one field based on values in another

billbois — Wed, 23 May 2012 15:33:58 GMT

Great solution, Oscar!

I need something similar, but it has to allow the user to select more than one option. In Oscar's demo, if the user selected A, C and D in the F1 field, the F2 field would have to select 1, 3 and 4.

In my case, the values are the same but the field names are different, so selecting A, C and D in F1 would select A, C and D in F2. I've tried GetFieldSelections() to no avail so far. Any suggestions?

Re: Use trigger to select values in one field based on values in another

oscar_ortiz — Wed, 23 May 2012 17:51:04 GMT

Bill,

In order to accomplish what you were aksing for I needed to create a new field in my first table that corresponds to data in the field from the second table.

Then using the follwoing expression as part of my trigger:

='('&Concat(Distinct F3,'|')&')'

In my example I have the orignal trigger for a single value associated to the field itself. The multiple value selection i have asscoiated to the button. Just check on the properties.

Good luck

Oscar

Use trigger to select values in one field based on values in another

billbois — Wed, 23 May 2012 18:57:28 GMT

Oh my, that's perfect! It's simple and elegant and exactly what I've been looking for. Thanks a million!

Re: Use trigger to select values in one field based on values in another

Anonymous — Thu, 13 Sep 2012 19:48:53 GMT

Oscar,

That's a great solution - Unfortunately, it does not appear to work for multiple text values. If I select a single value in the trigger field, it selects the corresponding value in the other fields (I need it to select in two other fields). However, if I select multiple values in the trigger field, I get no selections at all in the other two fields. Any idea how to fix this?

Thanks,

Kent

Re: Use trigger to select values in one field based on values in another

oscar_ortiz — Thu, 13 Sep 2012 20:21:56 GMT

Kent,

Use the button labeled "Test". The original document was to select one value in one field based upon one value on another. That is using a trigger based upon a field. The second request was to allow multiple values to be selected. Using the button I've accomplished this task.

Look at the properties of the button to see how it was done.

Good luck

Oscar

Re: Use trigger to select values in one field based on values in another

Anonymous — Fri, 14 Sep 2012 15:49:21 GMT

I discovered the problem with the posted example - Some of the values that could be selected contained spaces, which break QlikView's search unless they're enclosed in double quotes.

To get this to work every time, build a list that looks like this:

("Value 1"|"Item 7"|"Widget 12")

Re: Use trigger to select values in one field based on values in another

Anonymous — Wed, 19 Sep 2012 14:57:38 GMT

Interesting. I was using GetFieldSelections for this, but when you select all, it tries to select "ALL" in the other fields. So, I went back to the concat distinct method used in the example, but when I Clear, it clears the selection field, but not the two triggered fields unless I hit clear a second time.

Still looking for the ideal solution!

Re: Use trigger to select values in one field based on values in another

Thu, 27 Jun 2013 05:34:29 GMT

Is there any thread which explains the basic on how to use triggers in Qlikview? Can anyone please direct me there?

Re: Use trigger to select values in one field based on values in another

varunjain — Fri, 09 Aug 2013 07:19:49 GMT

Hi Oscsar,

Somehow, the solution provided by you isn't working on my QV doc. Please assist and let me know if I am missing out on something. Thanks

Re: Use trigger to select values in one field based on values in another

oscar_ortiz — Tue, 20 Aug 2013 19:18:28 GMT

It looks like you needed to change your variable:

FROM

=FieldIndex( 'Alpha', '$(vSelect)' )

=FieldIndex( 'Alpha', '$(VSelect)' )

Variables are case sensitive.

Hope this works for you.

Re: Use trigger to select values in one field based on values in another

Mon, 16 Mar 2015 06:25:49 GMT

Hi Oscsar,

Greetings!!

http://community.qlik.com/thread/156118

I am expecting your are the correct person to answer my question in above thread?

Please advice me the solution!

This is higly appreiciated!

Thanks,

Raju

Re: Use trigger to select values in one field based on values in another

Mon, 13 Apr 2015 03:52:05 GMT

I have a similar case and it would be great if you could help

I have two fields -

A - (All, x1,x2,x3,x4, unknown)

B - (x1,x2,x3,x4,x5,x7)

I only want B to get auto-selected when value of A is (x1 or x2 or x3 or x4); when all or unknown is selected, nothing in B should be selected, i.e. all B values should be selected.

B will have the same value as A except when A is All or unknown

is this possible? please help

Re: Use trigger to select values in one field based on values in another

Anonymous — Mon, 13 Apr 2015 15:16:58 GMT

Hello Hrithik,

You should be able to use set analysis along with the triggers to do this. You would set up a trigger where a selection in field A would select in field B with the search string something like this:

='("' & concat({$<FieldA-={'All','unknown'}>} distinct FieldA,'"|"') & '")'

Re: Use trigger to select values in one field based on values in another

Karim_Khan — Thu, 22 Dec 2016 08:16:19 GMT

Hi Oscar,

U really desrve OScar for Qlik

Re: Use trigger to select values in one field based on values in another

Anonymous — Thu, 07 Jun 2018 20:04:41 GMT

Hi Oscar,

Below is my data model where USER_LOB and INACTIVE_USERLOB are having the same values.

Requirement is "when USER_LOB' value is selected, the same value should be selected in INACTIVE_USERLOB and displayed in the chart.

But in my case when OGC is selected under USE_LOB, nothing is being filtered under INACTIVE_USERLOB

can you please help me with this? Thanks!

Re: Use trigger to select values in one field based on values in another

oscar_ortiz — Fri, 08 Jun 2018 21:40:40 GMT

Roshita,

You must be careful in this situation because of the possible associations in your data. In the example I've uploaded I tried to make the schema resemble your schema. But in my data set there is no relationship between AWM in USER_LOB and AWM in INACTIVEUSER_LOB. So this will not work for that particular LOB. It will work with other LOB's because there is a relationship within the data.

Hope this helps. Look at Sheet 1 for your particular request. Select a value in USER_LOB and click the Test LOB button. Check the properties under action for what I've done:

In your particular case you may want to change your schema to have a relationship between the USER_LOB and INACTIVE_USER_LOB.

Good luck

Oscar

Re: Use trigger to select values in one field based on values in another

Anonymous — Thu, 14 Jun 2018 15:44:51 GMT

Thanks much Oscar.