Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Typically the ID will need to include the domain.
Have a look at: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manag...
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."
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
Typically the ID will need to include the domain.
Have a look at: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manag...
@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.
I believe that is the case, yes.