4 Replies Latest reply: Mar 17, 2016 10:54 PM by jagan mohan rao appala RSS

    Section Access

    Chandni Bhowmick

      Hi,

       

      I want user A to not see the field 'MATERIAL' in the app. This is the source for my section access.

       

      qlik.png

       

      This is my section access code:

       

       

      Section Access;

      LOAD

          "ACCESS",

         upper( "USERID"),

          OMIT

      FROM [lib://Access/test1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

      Section Application;

       

      Welcome:

      LOAD

         

          Upper("USERID")as userid,

          NAME,

          OMIT

      FROM [lib://Access)/test1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      However, the user is still able to see the field MATERIAL.qlik1.png

       

       

       

      What am I doing wrrong?