Qliksense section access

[capriconuser]

I am trying to implement section access in hub .. so I do this 

first I did this 

Section Access;
Access_Table:
LOAD * INLINE [
    ACCESS,  NTNAME,  AuthKey
    ADMIN, administrator,  *
    ADMIN, testuser_1,  *
    ADMIN, IL\SA_SCHEDULER,  *
];
Concatenate(Access_Table)
LOAD
    ACCESS,
    NTNAME,
    AuthKey
FROM [lib://downloads (win1_administrator)/User_Access.xlsx]
(ooxml, embedded labels, table is Sheet1);

Section Application;

User_Access table 

ACCESS	NTNAME	            AuthKey
USER	W-AMKU1\jn	      101
USER	W-AMKU1\testuser_1	102
USER	W-AMKU1\testuser_2	103

and in sales tab 

Sales_Master:

LOAD
    ProductID,
    Country,
    Geography,
    Sales,
    Pick(Match(Country,'India','UK','USA','Canada','Japan','Austria'),101,102,103) as AuthKey
FROM [lib://downloads (w_administrator)/SALES.xlsx]
(ooxml, embedded labels, table is SALES);

sales table 

Product      Country	   Geography	      Sales
101	      India	     APAC	       10002
102	      Japan	     APAC	       2000
103	      UK	    AMEC	      3300
104	      Austria	    AMEC	      4000
105	      USA	    AMER	      7000
106	      Canada	     AMER	      3000

and in emp tab

EMP:

LOAD
    EMPID,
    ProductID
FROM [lib://downloads (w_administrator)/EMP.xlsx]
(ooxml, embedded labels, table is EMP);

Emp table 

EMPID	ProductID
E120	101
E130	102
E140	102
E150	103
E160	104

but when I login through testuser_1 this shows an error

how I resolve this ?

[capriconuser]

no.. but testuser_1 has access to stream @gmenoutis 

[gmenoutis · Accepted solution]

Users indeed must have access to a stream/app/sheet/object to see it, but they *also* need a license.

[capriconuser]

@gmenoutis 

is my authkey is correct ?

Pick(Match(Country,'India','UK','Japan'),101,103,102) as AUTHKEY

[gmenoutis]

Seems fine. But you test it by disabling section access (comment "section access;"). Then proceed to select the USERID you want as a value, and you will see if the associated data show.

[capriconuser]

@gmenoutis  yes thanku .. i allocate license and it works fine 🙂 thanks