topic Re: Allow/Disallow tabs without Section Access in QlikView

Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:07:20 GMT

Hi, I have a requirement, which I feel would be common in most implementations. Based on the user login, I need to allow/disallow tabs.

e.g.

Peter SH01

MacGill SH01

Peter SH02

This will be a sample maintenance, say SH01 is the sheet id. Based on the user login for e.g. Peter, he should get access to both sheets. MacGill should get access only to SH01.

Can you please help how to implement this.

Thanks,

Ram

Re: Allow/Disallow tabs without Section Access

tresB — Tue, 13 Aug 2013 11:11:47 GMT

Sheet Property->General->Show Sheet->Conditional

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:14:11 GMT

sorry tres, what would be the condition here?

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:15:20 GMT

let us say I capture the osuser() in a variable say vCurrentUser. How to use this variable in the condition?

Re: Allow/Disallow tabs without Section Access

tresB — Tue, 13 Aug 2013 11:15:36 GMT

Expression something like:

=If(OsUser()='Peter') // for whichever sheet you want to give access to Peter (in your case this has to be there in SH01)

Update: Or, even you can simply write : =OsUser()='Peter' // without IF

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:19:28 GMT

No tres, I can't hardcode usernames.

Re: Allow/Disallow tabs without Section Access

tresB — Tue, 13 Aug 2013 11:21:05 GMT

Then, what would be your logic?

Re: Allow/Disallow tabs without Section Access

MayilVahanan — Tue, 13 Aug 2013 11:25:14 GMT

Please refer this link

http://community.qlik.com/message/311475#311475

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:30:52 GMT

hmm. This link shows how to implement using section access. I can't afford to take the user name as input. The osuser is captured in a variable and based on that variable and the configuration i showed above it should decide to allow/disallow tabs.

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:33:46 GMT

Re: Allow/Disallow tabs without Section Access

tresB — Tue, 13 Aug 2013 11:34:38 GMT

See, you can always use variable instead of using the OsUser() directly, but in that case too, you have to compare that value with some string, right?

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:35:11 GMT

Re: Allow/Disallow tabs without Section Access

Tue, 13 Aug 2013 11:49:42 GMT

it is not a comparison against a string. it is a comparison against a static table that i have got.

Re: Allow/Disallow tabs without Section Access

tresB — Tue, 13 Aug 2013 12:07:52 GMT

You mean, you have table like:

Sheet	User
SH01	Peter
SH02	Jack

If so, you can give a try (not sure):

=If(osuser()=User, Sheet)='SH01' // for sheet1