topic Dynamic trigger on Activate Sheet in QlikView

Dynamic trigger on Activate Sheet

innashna — Sat, 16 Nov 2024 18:10:49 GMT

Hi,

I need for each tab in the model on 'Activate Sheet ' put trigger for Solution_Leg_Status='In Progress'. (As in the attached). Now we got requirement to activate this trigger only in case we don't have previous filters from previous sheets activated. How it can be implemented?

Thanks a lot.

Inna

Re: Dynamic trigger on Activate Sheet

cwolf — Thu, 27 Aug 2020 22:22:56 GMT

Create a dummy field for an alternative field selection:

TDummy:
LOAD 'In Progress' as Dummy AutoGenerate 1;

Now you can use followig expression for the Field in your trigger:

=if(GetSelectedCount(Solution_Leg_Status)=0 and Index(Concat(DISTINCT Solution_Leg_Status,','),'In Progress')>0,'Solution_Leg_Status','Dummy')

Re: Dynamic trigger on Activate Sheet

Kushal_Chawda — Thu, 27 Aug 2020 22:36:21 GMT

Which previous filter you want to look at because there could be many filters in that sheet and common to other sheet