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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Or
MVP
MVP

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.