topic Re: Qliksense section access in App Development

Qliksense section access

capriconuser — Mon, 20 Dec 2021 21:02:46 GMT

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 ?

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 08:19:46 GMT

You seem to be coming from the Qlikview side, no? "NTNAME" is not applicable for Qlik Sense; try "USERID" instead as a field name.

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 08:32:22 GMT

yes i used qliksense ..ok now i do this @gmenoutis

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

But this still shows same error

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 08:36:17 GMT

In the section access table, all field names AND values must be in capitals. Change UserId to USERID, testuser_1 to TESTUSER_1, AuthKey to AUTHKEY and so on. Obviously do the same to the connecting fields of data tables like AUTHKEY on Sales.

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 08:39:25 GMT

still same error when i click on application and when I log in through testuser_1 @gmenoutis

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 08:45:29 GMT

Hmm. Maybe the domain is missing? Generally you can debug this by temporarily disabling section access, going in the app, and adding a KPI with =OSuser() so you can see the username and the domain(shown as user directory), then put it accordingly. I would make a guess that the directory is local on the machine IL so you could try IL\TESTUSER_1.

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 08:58:14 GMT

IN qmc i have this @gmenoutis

and when I use KPI =osuser then I found this in OS USER

currently i am log in through admin but when i try to login in through test_user1 and then click on application then this shows an error

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 09:25:38 GMT

You have to use W-AMKU1\ADMINISTRATOR and W-AMKU1\TESTUSER_1 respectively.

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 09:39:06 GMT

@gmenoutis YES I used that both in script and in excel .. but still shows the same error

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 09:41:32 GMT

Strange that administrator works but test user not. Does the testuser have a licence allocated?

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 09:43:14 GMT

no.. but testuser_1 has access to stream @gmenoutis

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 09:45:40 GMT

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

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 10:03:51 GMT

@gmenoutis

is my authkey is correct ?

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

Re: Qliksense section access

gmenoutis — Wed, 31 Mar 2021 10:06:26 GMT

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.

Re: Qliksense section access

capriconuser — Wed, 31 Mar 2021 10:07:15 GMT

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