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: 
bharatkishore
Creator III
Creator 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
sunny_talwar

Try this

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

View solution in original post

7 Replies
bharatkishore
Creator III
Creator III
Author

@sunny_talwar  Any suggestions Sunny Bhai..

sunny_talwar

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

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

bharatkishore
Creator III
Creator III
Author

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.

sunny_talwar

Try this

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

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

sunny_talwar

Yes
bharatkishore
Creator III
Creator III
Author

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