5 Replies Latest reply: May 24, 2017 2:48 AM by Sibusiso Phumelo RSS

    Help with setting up access

    Joanna Versiani

      Hi everyone,

       

      I have set up a hidden access script, see it below:

       

       

      Section Access;
      LOAD ACCESS,
      NTNAME,
      USER,
      CC_Description
      FROM
      [\\auqldrv00fil1bi\work\qlikview\Corporate Accounting\SG&A Report\MasterData.xlsx]
      (
      ooxml, embedded labels, table is Access);

      Section Application;


      and I have attached the masterdata spread sheet where is looking the data for the security.

       

      I would like to have it user only seeing your department and only some users to see everything.

       

      however it is not working and everyone can see everything. The way I am filtering it is based on the CC_description which is in my data scrip as a group.

       

       

      maybe that is the reason? does anyone has any light?

       

       

      Thanks so much