topic Re: Hide Sheet from Certain People in QlikView

Hide Sheet from Certain People

Anonymous — Fri, 09 Feb 2018 03:45:35 GMT

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.

Re: Hide Sheet from Certain People

Anonymous — Fri, 09 Feb 2018 03:46:02 GMT

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

Re: Hide Sheet from Certain People

sudhakar1 — Fri, 09 Feb 2018 04:11:52 GMT

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

];

Re: Hide Sheet from Certain People

raman_rastogi — Fri, 09 Feb 2018 04:58:39 GMT

Mike

Use following Condition

Sheet Properties - General - Show Sheet- Conditional

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

Raman

Re: Hide Sheet from Certain People

kakani87 — Fri, 09 Feb 2018 05:07:40 GMT

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

Re: Hide Sheet from Certain People

Anonymous — Fri, 09 Feb 2018 12:48:44 GMT

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

I want to assign access based on their network path