Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Help on Triggers

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

Highlighted
Creator
Creator

Re: Help on Triggers

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

Highlighted

Re: Help on Triggers

Check attached

Highlighted
Creator
Creator

Re: Help on Triggers

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

Highlighted

Re: Help on Triggers

Try this

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

Highlighted
Creator
Creator

Re: Help on Triggers

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

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

Highlighted

Re: Help on Triggers

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....

Highlighted
Creator
Creator

Re: Help on Triggers

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?

Highlighted
Specialist III
Specialist III

Re: Help on Triggers

Check it out.

1.PNG