Help on Triggers

[vipingarg23]

Hi Team,

Please find the sample file as attached...

there are two listbox named test1 and test2.

I want if user select Q from test2 then it should select B from test1.

[sunny_talwar]

Just when Q is selected B is selected? No other selection do anything?

[vipingarg23]

Yes..Sunny..I am making adhoc report. So it should not impact any other selections..User can make any other selections as well...

[sunny_talwar]

Check attached

[vipingarg23]

Sunny..It is working fine but When I am making some other selections on test2, it is clearing all selections from test1.

For example:

I select Q, it will select B from test1. Now If I select R after selecting Q, it is clearing all selections from test1

[sunny_talwar]

Try this

=If(SubStringCount(Concat(DISTINCT '|' & test2 & '|'), '|Q|') = 1, 'B')

[vipingarg23]

No..it is also not working properly...

If I select A from test1 and P from test2 then it is clearing all.

[sunny_talwar]

There will be 500 different things you would want to do... I don't know them, so I cannot program them... unless you tell me all those behaviors..... Triggers are not always a good option to go to... but when you do... there is always the risk of missing out on one or the other thing....

[vipingarg23]

Yes..That I can understand....My requirement was if I select Q then it should select B and after that it should not impact any other selections...I know, through trigger, it is quite typical to match each and every possibility.

No Problem..Thanks for your help....

Is there any possibility in Qlikview to solve this problem except triggers?

[Qrishna]

Check it out.