Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
james
Creator III
Creator III

OnOpen Triggers not working

All I have 7 items on a trigger on open, and they seem to not work.... Is there a maximum number that is preferred?

2 Replies
sunny_talwar

I am not aware of max number of triggers. Are they may be conflicting each other for some reason? Can you share a sample?

james
Creator III
Creator III
Author

OnOpen

1 Unlock and Clear all

2 Select in field             Date      =MaxString({$<Date={"=$(=vMaxDateTrigger)"}>}Date)

3 Select in field           sAMAccountName    =upper(SubField(OSUser(),'\',2))

4 Select Possible GroupName

Than group Name has an on activate trigger that sets a variable

    

vAD_GROUP_USW=if(GroupName= 'Qlikview US W',if(    WildMatch(GetFieldSelections(sAMAccountName),upper(SubField(OSUser(),'\',2))),1,0),0)
vAD_GROUP_USE=if(GroupName= 'Qlikview US E',  if(WildMatch(GetFieldSelections(sAMAccountName),   upper(SubField(OSUser(),'\',2))),1,0),0)
vAD_GROUP_GLOBAL=if(GroupName= 'Qlikview Global',  if(WildMatch(GetFieldSelections(sAMAccountName),   upper(SubField(OSUser(),'\',2))),1,0),0)

5 Select in Field Region = vRegion

6 Activate Sheet = v Sheet