Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

Creator III
Creator III

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