2 Replies Latest reply: Feb 2, 2016 4:23 PM by James Phillips RSS

    OnOpen Triggers not working

    James Phillips

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

        • Re: OnOpen Triggers not working
          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?

            • Re: OnOpen Triggers not working
              James Phillips

              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