4 Replies Latest reply: Nov 8, 2017 9:54 AM by Aehman K RSS

    Qliksense section access

    Sheetal Borchate

      Hi,

       

      I am trying section access in Qliksense. I have list of userid and I want to give Profit Center wise section access

      ex.

      Query1:

      Userid, profit center

      A,All Profit center

      B,123

      C,234

      I want user A to see all the Profit Center available but it is showing only 123 & 234.

      I tried keeping profit center blank, by putting *. But it not working

       

      Query2:

      Userid,Plant,Profit Center

      A,2011,123

      B,2012,234

      B,2012,456

      C,All plant, All Profit Center

      Here I want to give data level section access like user A have access to plant 2011 and Profit center 123  and User C have access to all plant and all profit center then how can I achieve this??

       

       

       

      Help!!

        • Re: Qliksense section access
          Shraddha Gajare

          Make sure that everything you write under Section access script is in UpperCase

          Section Access;

           

          Load * Inline [

          ACCESS , USERID, "PROFIT CENTER"

          ADMIN, A,

          USER,B,123

          USER,C,234

          ];

           

          Section Application;

          • Re: Qliksense section access
            Aehman K

            Star is *;

             

            /////////////////////////////////////////////

            Section access;

             

            LOAD * inline [

            ACCESS, USERID,PROFIT CENTER

            USER, INTERNAL\SA_SCHEDULER, *

            USER, ABCDomain\UserA, *

            USER, ABCDomain\UserB, 123

            USER, ABCDomain\UserC, 234

            ];

             

            Section Application;

             

            /////////////////////////////////////////////

             

            Not sure about your 2nd SA query....

            It is contradicting 1st query. User A has full access to Profit Center and then in 2nd query you are giving access to only 123 Profit Center.

            To give the user access by NT name either check their Domain in Active Directory or use =OSUSERS() in text box for correct NT Name and use that name instead of ABCDomain\USER...

             

            Internal Scheduler is an Admin account in QMC, used to reload the apps doesn't hurt to have it in script.

            And if you get locked out of your app then right click on the app>'Open without Data'

            That would open the script to modify the script.