i have around 100 users per Stream in Qlik Sense. Now i would like to limit couple of users so they can see just their data.
I am using following code:
star is *;
Section access;
Sectionaccess:
LOAD
[ACCESS],
'EU\'&NTNAME as NTNAME ,
ZUGRIFFSGRUPPE
FROM [lib://DATA_TEC/Flatfiles/OPPORTUNITIES/Zugriffstest_Vertrieb_KPIs - Kopie - Kopie.xls]
(biff, embedded labels, table is ACCESS$);
Concatenate LOAD * INLINE
[ACCESS, NTNAME,ZUGRIFFSGRUPPE
ADMIN, INTERNAL\SA_SCHEDULER,ALLES //Dieser User muss für den immer hinterlegt sein
];
Section Application;
WerDarfWas:
LOAD
ZUGRIFFSGRUPPE,
Rolle
FROM [lib://DATA_TEC/Flatfiles/OPPORTUNITIES/Zugriffstest_Vertrieb_KPIs - Kopie - Kopie.xls]
(biff, embedded labels, table is Rolle$);
My problem is that in Excel file i need to insert each NTName to give the rights for the each employee. I would like to say in excel that those couple of employees can see only their data and afterwards,all other users are able to see everything.
I tried with * in NTName column but did not worked. All other users get the message Access denied.
When i insert each NTName with the Rolle All then each employee can see this app.
