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

[#1]

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.

[#2]

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

[varunjain]

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

[oscar_ortiz]

It looks like you needed to change your variable:

FROM

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

TO

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

Variables are case sensitive.

Hope this works for you.

[#5]

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

[#6]

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

[Anonymous]

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,'"|"') & '")'

[Karim_Khan]

Hi Oscar,

     U really desrve OScar for Qlik

[Anonymous]

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!

[oscar_ortiz]

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

[Anonymous]

Thanks much Oscar.