Discussion Board for collaboration on QlikView Security and Governance.
I have a report. Users should be access data based on DNAME.
User1 (ADMIN) should access all the data - ACCOUNTS,HR,SALES.
User2 should access HR data.
User 3 should access SALES data.
But User1 should access NULL values always.
Please update the attached file and provide.
Thanks in advance.
Go to Solution.
If user wants to access all the values other than then use *, to access nulls just give empty.
LOAD * INLINE [
ACCESS, USERID, PASSWORD,DNAME
ADMIN,ADMIN,ADMIN,* // Access all values other than Nulls
ADMIN,USER1,USER1, // To access values
USER, USER4, USER4, // USER4 can Access all values including nulls
Hope this helps you.
Thank you so much.It is perfect.
Thank you so much. It is working for NULLs also.