Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
bharatkishore
Contributor III

Help in Triggers

Hi All,

I needed your help in triggers. i have 2 tables and they are not linked and  in that i have two fields A and B.

Now whatever i select in table A i need to get in table B for that i have used triggers. So in that i have used trigger on Field event triggers and on On-Select. 

I have given B field in Field and in expression i have given the following one ='("'& Concat(B,'"|"') &'")'

This is working fine. But the problem is when i un-select field A all the columns are getting selected in Field B which should not happen.

IF i un-select field A then field B also should be cleared or un-selected.

Can you please tell me how to do.

Thanks,

Bharat

1 Solution

Accepted Solutions

Re: Help in Triggers

Try this

=If(GetSelectedCount(Material_Type_Series) > 0, '("'& Concat(Material_Type_Series,'"|"') &'")')
7 Replies
bharatkishore
Contributor III

Re: Help in Triggers

@sunny_talwar  Any suggestions Sunny Bhai..

Re: Help in Triggers

I am a little confused, you are triggering on Field B based on an expression on Field B?

='("'& Concat(B,'"|"') &'")'

bharatkishore
Contributor III

Re: Help in Triggers

Sunny Bhai, 

please find attached qvw.

 i have  fields called Material_Type_Series  and IB_Material_Type_Series . Now when i filter data in Material_Type_Series the same data is getting filtered in IB_Material_Type_Series . But when i un-select the selection IB_Material_Type_Series  is not getting un-selected. Whatever columns are present in Material_Type_Series  those are not getting cleared in IB_Material_Type_Series .

I have added trigger for Material_Type_Series in field event triggers.

Please let me know if you need anything more.

Re: Help in Triggers

Try this

=If(GetSelectedCount(Material_Type_Series) > 0, '("'& Concat(Material_Type_Series,'"|"') &'")')
bharatkishore
Contributor III

Re: Help in Triggers

Thank you Sunny Bhai.. worked perfectly.

I am explaining your logic as per my understanding.. please correct me if am wrong..

So whenever if we select material_type_series filter then that trigger will work because the get selected count is > than 0 and if we remove since the count is less than 0 it is showing as it is.

Am i correct Sunny bhai..

Re: Help in Triggers

Yes
bharatkishore
Contributor III

Re: Help in Triggers

Thank you so much Sunny Bhai.. Thanks a lot..