topic Re: Help in Triggers in QlikView

Help in Triggers

bharatkishore — Thu, 25 Jul 2019 09:28:54 GMT

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

Re: Help in Triggers

bharatkishore — Thu, 25 Jul 2019 11:33:46 GMT

@sunny_talwar Any suggestions Sunny Bhai..

Re: Help in Triggers

sunny_talwar — Thu, 25 Jul 2019 11:43:30 GMT

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

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

Re: Help in Triggers

bharatkishore — Thu, 25 Jul 2019 11:52:47 GMT

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

sunny_talwar — Thu, 25 Jul 2019 12:07:48 GMT

Try this

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

Re: Help in Triggers

bharatkishore — Thu, 25 Jul 2019 12:31:48 GMT

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

sunny_talwar — Thu, 25 Jul 2019 12:33:45 GMT

Yes

Re: Help in Triggers

bharatkishore — Thu, 25 Jul 2019 12:38:59 GMT

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