topic Re: How to hide the tab based on user security in QlikView

How to hide the tab based on user security

Fri, 19 Feb 2016 13:06:17 GMT

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.

Re: How to hide the tab based on user security

sunny_talwar — Fri, 19 Feb 2016 17:08:32 GMT

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

Re: How to hide the tab based on user security

Mon, 29 Feb 2016 13:07:43 GMT

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,

From DataAccess_1299.qvd (qvd) where 1 = 1;

SECTION Application;

HR_Check:

LOAD [~NTNAME],

[~IC_HR],

[~HR_FLAG]

FROM HR_DataAccess_1299.qvd (qvd);