How to hide the tab based on user security

[#1]

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.

[sunny_talwar]

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*')

[#3]

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);