7 Replies Latest reply: Feb 3, 2016 10:34 PM by sunish sultania RSS

    Section Access

    nitish Jillundra

      Hi All,

      Hope you all doing well.

       

      I am having a small query regarding section access. I am having a scenario which is given below:

       

      there are 4 users and there are 8 no. of sheets in my application. I want to implement section access in a way that all 4 users will be able to see all data of first 4 sheets. but the data should get reduced in other four sheets for example:

       

      if they are viewing sheet no 1-4 than they should see all data for all 4 users

      but if they are going on to sheet no 5-8 than they should be able to see there respective data.

       

      kindly suggest if this scenario can be done. will be thankfull.

       

      email : coolnitish.n@gmail.com

        • Re: Section Access
          Oleg Troyansky

          Security definitions cannot be dependent on Sheets, so it would be impossible to implement exactly what you are asking for. You can look for possible work-around solutions.

           

          It's important to understand that the data is either reduced (for all sheets) or it's not reduced at all. Possible solutions:

           

          - Split your application into two. Sheets 1-4 in App #1 would not require any data reduction, while Sheets 5-8 in App #2 would be implemented with data reduction

           

          - build your data model in such a way that the data elements that are used in sheets 1-4, are associated with all employees, while the data elements that are used in sheets 5-8, are only associated with individual employees. This way, data reduction could only impact the data that's used in sheets 5-8.

           

          Cheers,

          Oleg Troyansky

          Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

          • Re: Section Access
            Henry Cabrera

            Hi,

            You can use QVUser () or OSUser () functions to restrict access to each tab in sheet properties, display sheet, conditional ..

            hope will be your help,

            greetings,

            Henry C.hojaprop.jpg

            • Re: Section Access
              Gysbert Wassenaar
              section access in a way that all 4 users will be able to see all data of first 4 sheets. but the data should get reduced in other four sheets for example:

              That's not possible. There is only one data model for the entire document. All objects on all sheets use the same data model. So it is not possible to reduce the date model only for some part of the document with section access. You will have to use set analysis expressions and make sure the user cannot create or modify objects.

                • Re: Section Access
                  nitish Jillundra

                  Hi Gysbert, thanks for your response can you let me know how can I mention these things in set analysis.

                  coz as mentioned by oleg & henry I am having only one data model and the filters can be same in all the 8 sheets. so can you give me the possible way out how can I restrict the things with the help of section access and set analysis.

                   

                  thank you

                • Re: Section Access
                  sunish sultania

                  If licensing is not an issue then create 2 apps.

                  Otherwise,

                  I have a assumption that page 1-4 are summary and 5-8 are detail for the same.

                   

                  Had a similar situation , so created a summary data model also and concatenate with main data model.

                  Ex: say you key is region i,e. east west north and south.

                  in the summary data model make region as nation.

                   

                  Define section access for person 1 as nation and north, person 2 as nation and south and so on.

                   

                  In sheet 1-4 use set analysis to display only "nation" region

                  and in sheet 5-8 use set analysis to display anything not belonging to region "nation".

                   

                  email: sunish.sultania@gmail.com