2 Replies Latest reply: Aug 27, 2018 10:47 AM by Piet Hein van der Stigchel RSS

    Section Access with conditions

    Anindya Manna

      Hi All,

       

      I have million of User who will login to Qliksense app and i have field name Status which have 'Completed' and 'Active' values.

      Out of million User ID , i wan to give access to 4 User ID('A','B','C','D') for both status so that they can see all data associated with both 'Completed' and 'Active' and for remaining User IDs , i want to restrict them to see only data associated with 'Active' Status.

       

      problem is that , i have information only about Those 4 User IDs for which i need to give both value access. For rest of them i need to restrict the access.

       

       

      Thanks

        • Re: Section Access with conditions
          Anton van Keep

          Hi Anindya Manna,

          You could try the following:

           

          First only load the users which should see the completed values. And then add all the other users (including the earlier loaded 4) with "active" as value.

           

          SectionAccessTable:

          LOAD

          USERID,

          'Completed' AS STATUS

          FROM USERID_Table

          WHERE MATCH(USERID,'USERID1','USERID2','USERID3','USERID4');

           

          CONCATENATE (SectionAccessTable) LOAD

          USERID,

          'Active' AS STATUS

          FROM USERID_Table;

          • Re: Section Access with conditions
            Piet Hein van der Stigchel

            I think you can use * for NTNAME, so you give access to both for those four users and restrict for all the rest like this

            Please note the DUMMY user, it is needed to give access to COMPLETED for users A,B,C,D

             

            Section Access;

            Load * Inline [NTNAME,ACCESSGROUP

            A,*

            B,*

            C,*

            D,*

            *,ACTIVE

            DUMMY,COMPLETED

            ];

             

            SECTION Application;

            star is *;

            Load * Inline [ACCESSGROUP

            ACTIVE

            COMPLETED

            ];