Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
innashna
Contributor II
Contributor II

Dynamic trigger on Activate Sheet

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

Labels (2)
2 Replies
cwolf
Creator III
Creator III

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')

cwolf_0-1598566927403.png

 

Kush
MVP
MVP

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