Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anormand
Contributor
Contributor

Session access with users on external file

Hello community,

I'm currently working on an app that reduces data using "Session Access".
This app will be accessed from 2 ways :

1 - Admin (me) : I can see everything.

2 - Users (a lots, more than 800) : only see their personnal data.

 

For the session access I wrote something like this :

LOAD
'USER' AS ACCESS
,'MYSERVER\' & Lower(ID) AS USERID
,Upper(NOM) & ' ' & Upper(Prénom) AS RDVVENDEUR
,Upper(NOM) & ' ' & Upper(Prénom) AS RDVVERBATIM
,null() AS OMIT
FROM [lib://Folder/ExcelFileWithUsers.xlsx]
(ooxml, embedded labels, table is [tab1]);
Concatenate LOAD
ACCESS
,USERID
,RDVVENDEUR
,RDVVERBATIM
,OMIT
Inline [
ACCESS,USERID,RDVVENDEUR,RDVVERBATIM,OMIT
ADMIN,INTERNAL\SA_SCHEDULER,*,*,
ADMIN,MYSERVER\mylogin,*,*,
];

 

The part with "inline" that contains my login and admin right works.

But the part with the excel file looks to fail.

Is there a restricted use to only inline ?

 

Thanks in advance,

Adams

Labels (1)
1 Reply
anormand
Contributor
Contributor
Author

This morning I did a test, I added 1 user on the inline part, and it's works.

Why the "from excel" part don't work ?