2 Replies Latest reply: Feb 29, 2016 8:07 AM by Rajani Thumma RSS

    How to hide the tab based on user security

    Rajani Thumma

      Hi,

      I am new to qlik view.

      How to hide the tab based on user security, I have 3 tabs in my application

      Two tabs data is coming from financials , other tab is HR. I need to hide 3 rd Tab based on user registration.

        • Re: How to hide the tab based on user security
          Sunny Talwar

          You can use OSUser() function to give access to only certain individuals:

           

          WildMatch(OSUser(), '*User1*', '*User5*')

           

          You will do this on the sheet properties -> General Tab -> Show Sheet -> Conditional -> WildMatch(OSUser(), '*User1*', '*User5*')

            • Re: How to hide the tab based on user security
              Rajani Thumma

              Hi Suuny ,

              Thanks for your response. But i have so many users . we setup security in backend. We have restriction flag Y or N . Based on this i need to hide tab. Based on this i setup security but i have issue with if one user register for two institutes(IC), in this one institute have Y other N .This scenario i m not able to get.

               

              I used below script.

               

              SECTION Access;

               

              Directory;

              LOAD ACCESS,

                   NTNAME,

                   IC

              From DataAccess_1299.qvd (qvd) where 1 = 1;

               

               

              SECTION Application;

               

              HR_Check:

              LOAD [~NTNAME],

                   [~IC_HR],

                   [~HR_FLAG]

              FROM HR_DataAccess_1299.qvd (qvd);