7 Replies Latest reply: Dec 15, 2016 8:50 AM by S Satti RSS

    sheet Level access

    mahesh babu

      Hi All,

      i have qvw in these iam having sheet1 and sheet2  , and i want to provide these sheet2 access to particular users .

       

      user details :

      uday.kumar@outlook.com

       

       

      when user uses these userdetails to login then only sheet2 should be visible others should see all the  sheet1 .

       

      can any one help me on these .

       

      Thanks In advance !

        • Re: sheet Level access
          Sasi Vardhan KV

          Section Access;

           

          LOAD ACCESS,

               NTNAME,

               SAREP,

               NM

          FROM

          '..\..\..\Dashboard\SectionAccess.xlsx'

          (ooxml, embedded labels, table is SA);

           

          Then you add the sheet access coding directly underneath

           

          Section Application;

           

          Sheet_Security:

          LOAD USERS as NM,

               SH01,

               SH02,

               SH03,

               SH04,

               SH05,

               SH06,

               SH07,

               SH08

          FROM

          '..\..\..\Dashboard\SectionAccess.xlsx'

          (ooxml, embedded labels, table is SHEETS);

           

          My Section Access table looks like you would expect and the NM column is to specify their role, MGR or NON for different sheet access, i.e.

          NTNAME   SAREP   NM

          him            Richard   NON

          her             Mike       NON

          mgr1           *            MGR

          mgr2           *            MGR

           

          and the Sheets Table looked like so:

           

          USERS  SH01  SH02  SH03.... SH07 SH08

          NON         1         1         1           0        0

          MGR         1         1         1           1        1

           

          Then set the condition property for each respective sheet to show if the flag for that sheet is 1, i.e.:

          SH08=1

           

          Then reload!

          • Re: sheet Level access
            Hemanth Aanichetty

            Hi Mahesh,

             

            Refer the below link:

             

            QlikView Section Access Examples

             

            it might be very helpful

             

            Regards

            Hemanth

            • Re: sheet Level access
              kalyani vintha1

              Hi,

              suppose if you have sheet1 and sheet2 in your application.

              you can apply section access like this...as fallows

              In section access we must have to give some basic credentials these are

              ACCESS-access type ntg but this user is admin or user

              USER ID-user id is credential to user ntg but username

              PASSWORD-we have to give the passwords for every users.

              and

              if you want to apply at sheet level..you have to add additional credentials like sheet names you have to add in

              section access.

              at sheet level credential you want to display that sheet to particular user you have to add 1 in that user.

              you don't want to display that sheet to particular user you have to add 0.

              Section Access;

              LOAD * INLINE [

                  ACCESS, USERID, PASSWORD, SHEET1, SHEET2

                  ADMIN, ADMIN, 123, 1, 1

                  USER, USER1, 1234, 1, 0

                  USER, USER2, 1235, 0, 1

               

              ];

              Section Application;

               

              from this..admin will see the both the sheets

              user1 will see the sheet1 only

              and

              user2 will see the only sheet2.

               

               

               

              Thanq.

                • Re: sheet Level access
                  mahesh babu

                  Hi Kalayani.

                  Thanks for providing the detail information for the sheet level access  very easy to understand .

                  but i have question here

                  I  cant the information  of the password from the user .

                  my changeling  is when ever  user use his Credentials  as  username based on that sheet should be visible .

                  for Eg: if user is logged with mahesh@polash.com  then user should be able  to his sheets .

                   

                  Sry if my question not clear.

                   

                  can you help me to solve this issue.

                   

                  Thanks in advance !

                  Regards

                  Mahesh.

                • Re: sheet Level access
                  S Satti

                  Hi Mahesh,

                   

                  we have to create section access for this like below.

                   

                  Section Access;

                  LOAD * INLINE [

                      ACCESS, USERID, PASSWORD

                      ADMIN, ADMIN, ADMIN

                      USER, SA, SA

                      USER, TA, TA

                  ];

                   

                  Reload the QVW File and go to sheet Properties..

                   

                  Genaral Tab:

                   

                  Show Sheet :

                   

                  Conditional: here we have write like below.

                   

                  =QVUSER()='SA'

                   

                  PRESS OK.

                   

                  CLOSE THE QVW File And login with TA. TA user Don't Have Access sheet 1 so its not visible.

                   

                   

                  Regards

                  Sathish.

                  • Re: sheet Level access
                    kalyani vintha1

                    Hi Mahesh,

                     

                    you have to set the passwords as of you and your client understanding.

                    and

                    Your Requirement is ..

                    you have to show  sheet2 information  to only one particular user and remaining for all the users you don't want to show the sheet2 information right.

                    suppose if you want display sheet2 information to only user3 and remaining all the users can't see the sheet2 information,

                    and admin also can't see the sheet2 information when you are going to log in with admin credentials initially.

                    but after reloading the application in admin level .admin can access all the sheets information along with sheet2.

                    and normal users at any cost they didn't see the sheet2 information.

                    and user3 can only access the sheet2 information at any cost.


                    you can do like this:

                    Section Access;

                    LOAD * INLINE [

                        ACCESS, USERID, PASSWORD, SHEET1, SHEET2

                        ADMIN, ADMIN, 123, 1, 0

                        USER, USER1, 1234, 1, 0

                        USER, USER2, 1235, 1, 0

                         USER,USER3,1236,0,1

                     

                    ];

                    Section Application;

                     

                     

                     

                    and

                    I given the reply as of i understand your requirement,

                    this is not your final requirement,

                    share the what is your exact requirement,

                     

                    Thanq.

                    • Re: sheet Level access
                      S Satti

                      hi Mahesh,

                       

                      have checked my post...

                       

                      Regards

                      Sathish