Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlik view.
How to hide the tab based on user security, I have 3 tabs in my application
Two tabs data is coming from financials , other tab is HR. I need to hide 3 rd Tab based on user registration.
You can use OSUser() function to give access to only certain individuals:
WildMatch(OSUser(), '*User1*', '*User5*')
You will do this on the sheet properties -> General Tab -> Show Sheet -> Conditional -> WildMatch(OSUser(), '*User1*', '*User5*')
Hi Suuny ,
Thanks for your response. But i have so many users . we setup security in backend. We have restriction flag Y or N . Based on this i need to hide tab. Based on this i setup security but i have issue with if one user register for two institutes(IC), in this one institute have Y other N .This scenario i m not able to get.
I used below script.
SECTION Access;
Directory;
LOAD ACCESS,
NTNAME,
IC
From DataAccess_1299.qvd (qvd) where 1 = 1;
SECTION Application;
HR_Check:
LOAD [~NTNAME],
[~IC_HR],
[~HR_FLAG]
FROM HR_DataAccess_1299.qvd (qvd);