Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need Help.
I want to apply row-level access based on the user who is accessing the dashboard.
The user should see and search only the rows where the username (who is accessing the dashboard) matches the value in the column "assigneduser".
All users are in Active directory.
i applied the section access as below , but it's not working.
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTIONFIELD
ADMIN, DIR\<MySelf>, *
ADMIN, DIR\2758_Qlik_STG, *
ADMIN, INTERNAL\SA_SCHEDULER, *
USER, DIR\RAHUL.T, RAHUL.T
USER, DIR\ROHIT.K, ROHIT.K
USER, DIR\CHETAN.D, CHETAN.D
USER, DIR\SAI.P, SAI.P
];
Section Application;
Adminasset:
LOAD
AutoNumber(assetid) as AssetID,
assetid as AdminassetId,
computername,
upper(assigneduser) AS REDUCTIONFIELD,
assettype & '-' & pcmodel & '-' & serialnumber as Asset,
assettag
FROM $(vQVDPath)\assetinfo.qvd(qvd)
Try this
(Note : keep all field names in upper case)
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTIONFIELD
ADMIN, DIR\<YourAdminUser>, *
ADMIN, INTERNAL\SA_SCHEDULER, *
USER, DIR\RAHUL.T, RAHUL.T
USER, DIR\ROHIT.K, ROHIT.K
USER, DIR\CHETAN.D, CHETAN.D
USER, DIR\SAI.P, SAI.P
];
Section Application;
Adminasset:
LOAD
AutoNumber(assetid) as AssetID,
assetid as AdminassetId,
computername,
upper(assigneduser) AS REDUCTIONFIELD, // Ensure this is upper case to match the section access
assettype & '-' & pcmodel & '-' & serialnumber as Asset,
assettag
FROM $(vQVDPath)\assetinfo.qvd(qvd);
Hi Chanty4,
Do you mean in the section access or all the columns in the data load ?
All values are in caps.
Also, i just realized that it's not even showing a list of users in the column NTNAME.
@Noob3 , You already have the same question open in another forum, although it was posted in the wrong forum. In any case, both responses in the forums are correct. Please keep your question in only one forum to maintain good practices and keep the community organized, closing the thread once your issue is resolved.
Row level Section access- based on dashboard user ... - Qlik Community - 2476027
Thanks