3 Replies Latest reply: Aug 15, 2018 2:36 PM by Jasmeen Kaur RSS

    Qlik Sense Section Access

    Jasmeen Kaur

      Section Application mandatory field for giving section access in Qlik Sense

        • Re: Qlik Sense Section Access
          Shraddha Gajare

          Please elaborate your question with dummy data and expected output

          • Re: Qlik Sense Section Access
            Bala Bhaskar

            Try like this:

            If you create the app in Desktop, you'll need to import it into Qlik Sense using QMC.  If you create the app in QMC hub, there is no need to import.

             

            Next, you publish the application in a Stream which is available for all users.User will see the part of the data which Section Access allows.

             

            In Desktop, Section Access doesn't work, you see all data.

             

            Section Access;

            LOAD * inline

            [

            ACCESS,USERID

            USER,U

            USER1,U2

            ];

            Section Application;

             

            ABC:

            LOAD

                *

            from abc.csv;

             

            OR

             

            Data reduction based on user id

             

            section access;

            LOAD * inline

            [

            ACCESS, USERID,REDUCTION, OMIT

            USER, AD_DOMAIN\ADMIN,*,

            USER, AD_DOMAIN\A,1,

            USER, AD_DOMAIN\B, 2,NUM

            USER, AD_DOMAIN\C, 3, ALPHA

            ADMIN, INTERNAL\SA_SCHEDULER,*,

            ];

            section application;

            T1:

            LOAD *,

            NUM AS REDUCTION;

            LOAD

            Chr( RecNo()+ord('A')-1) AS ALPHA,

            RecNo() AS NUM

            AUTOGENERATE 3;

            • Re: Qlik Sense Section Access
              Jasmeen Kaur

              Thanks Bala for detailed explanation

               

              One more thing I have requirement to display  limited categories under Product(I want to apply Section access on both categories and products).

               

              Let me know how to achieve it.