6 Replies Latest reply: Oct 8, 2015 9:24 AM by Chris Smith RSS

    Cannot get Section Access to work

      Hi all,

       

      Myself and my organisation are very new to Qlikview and are currently evaluating it before deciding whether or not to buy. One of the deciding factors for us will be security.

       

      I'm trying to implement section access to a test document but I simply cannot get it to work. My script is below (data has of course been scrubbed of anything potentially identifiable to our organisation!)

       

      SECTION ACCESS;

      LOAD * INLINE [

          ACCESS, NTNAME, SectorName

          ADMIN, TP\user1, Sector A

          USER, TP\user2, Sector B

          USER, TP\user3, Sector C

      ];

      SECTION APPLICATION;

       

      What I would expect here is that TP\user1 can only see data pertaining to Sector A, TP\user 2 to Sector B and so on. Unfortunately, when I either view the report locally on Qlikview desktop or deploy onto Qlikview server, each of these three users can see all sectors.

       

      I have already selected "Initial Data Reduction Based on Section Access" and "Strict Exclusion" within document properties. If I change the script to use USERID and PASSWORD in place of NTNAME, it prompts me when I open the document but no reduction seems to apply. I've also commented out the SECTION ACCESS and SECTION APPLICATION lines to add it as a standard table and can confirm it appears to filter exactly as expected.

       

      I understand that this is probably a really simple question but for the life of me I cannot see what it is that I am doing wrong. If someone could please help it would be much appreciated.

       

      Thanks in advance,

       

      Chris