Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Hide Sheet from Certain People

is it possible to hide sheet from certain people by their domain name(Log in) , how can I do this

I would like Sheet1 from hidden from certain. Can someone help me set this up, I will learn from the example and mirror.

5 Replies
Highlighted
New Contributor II

Re: Hide Sheet from Certain People

I want to hide the sheet not the object or tables within. Just to clarify

Highlighted
New Contributor

Re: Hide Sheet from Certain People

Hi,

You can even go for section access in the appln as below

I. Create Section Access

SECTION ACCESS;

LOAD * INLINE [

USERID,PASSWORD, ACCESS

ADMIN,123, ADMIN

USER1,123,USER

USER2,125,USER

];

SECTION APPLICATION;

LOAD * INLINE [

USERID,SHEETID

USER1,SH01

USER2,SH02

];

Highlighted
Partner
Partner

Re: Hide Sheet from Certain People

Mike

Use following Condition

Sheet Properties - General - Show Sheet- Conditional

WildMatch(Subfield(OSUse(),'\',2),'Domain Name')>=1

Raman

Highlighted
Valued Contributor

Re: Hide Sheet from Certain People

Hey Mike try this

Right click sheet  properties > In conditional give 0 > OK

now the sheet is hidden.

To see the same again you follow the steps to

settings > Document properties > Sheet tab > select the hidden sheet > Properties > In show sheet Remove conditional=0 and tick Always > Ok

Highlighted
New Contributor II

Re: Hide Sheet from Certain People

Is it possbile to do this by the person computer login .

I want to assign access based on their network path