Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Highlighted

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.

Highlighted

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