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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
sharu055
Creator
Creator

Qliksense Section Access Script giving error.

I am migrating my qlikview app to qliksense, in qlikview we use the below script for section access to provide access to users. If i use the same script in qliksense its not working in DEV cloud and givibg the popup below screenshot. I am a part of ADMIN here i only running the script. Please help in writing qliksense script for section access. Thanks in advance.

Qlikview Script: 

Section Access;

LOAD Upper(ACCESS) as ACCESS,
NTNAME ,
Upper(PERMISSION) as PERMISSIO

N1

FROM [lib://DataConnection//Section Access.xlsx]

(ooxml, embedded labels, table is Section_Access);

Section Application;

Data example:

ACCESS NTNAME PERMISSION
ADMIN 123ABC *

 

I used the proper path for qliksense to fetch the data, after refresh i am getting the below popup. I am into Admin and permission is *. Not sure why i am getting below popup, Its in Dev not moved to UAT. 

sharu055_0-1740050166937.png

 

 

1 Solution

Accepted Solutions
5 Replies
Or
MVP
MVP

Given that NTName is a legacy field from QV that is not recommended for use in QS, I'd suggest adjusting your Section Access accordingly rather than attempt to debug the current structure.

"NTNAME is a legacy QlikView field and it is recommended to use USERID if QlikView is not using the same security table."

sharu055
Creator
Creator
Author

I changed the NTNAME field header to USERID and reload the script in qliksense, getting same error again.


LOAD

Upper(ACCESS) as ACCESS,
USERID ,
Upper(PERMISSION) as PERMISSION1

sharu055_0-1740050845962.png

 

 

Or
MVP
MVP

sharu055
Creator
Creator
Author

@Or Thanks you so much for the reply, i can reload it now it works, should all the USERID must have Domain name or only those who refresh the dashboard. 

Or
MVP
MVP

I believe that is the case, yes.