Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

Help on Triggers

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.

9 Replies
sunny_talwar

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

vipingarg23
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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?

krishna_2644
Specialist III
Specialist III

Check it out.

1.PNG