Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to hide the tab based on user security

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.

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

Not applicable
Author

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