topic Sheet visability in QlikView

Sheet visability

Wed, 09 Jan 2013 10:52:37 GMT

I have two distinct groups of users, finance and clinicians.

In my QVW I have a number of sheets that both groups use to discuss performance. However, I have one sheet that is only applicable to the finance team. Is it possible to hide it so the clinicians cannot see it?

Thanks

Ian

Re: Sheet visability

fdelacal — Wed, 09 Jan 2013 11:02:46 GMT

HI YOU CAN TRIE WITH SECCION ACCES. I RELINK TO A DISCUSION OF THIS.

THIS IS A WAY TO SOLVE YOUR PROBLEM.

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

HOPE IT HELPS YOU

Re: Sheet visability

Wed, 09 Jan 2013 11:12:49 GMT

I've had a look at that, but I am not trying to hide fields or data. i am just trying to hide an individual sheet instead

Re: Sheet visability

Wed, 09 Jan 2013 11:18:35 GMT

Hi,

Let me give you some hints rather.

You can look at Sheet properties >> General Tab >> Show Sheet (Conditional). In this box you can enter an expression that should return either True() or False() based on various conditions. You'll probably be able to use the Match() & OSUser() or QVUser() functions inside an If statement to make it work.

Pseudo code: If username = 'Ben' or 'Sara' then return True() else return False().

If(Match(OSUser(),''Ben'',''Sara'')>0, true(),false())

Enjoy,

Re: Sheet visability

fdelacal — Wed, 09 Jan 2013 11:18:39 GMT

RIGHT CLICK ON THE SPECIFIC SHEET GO TO PROPERTIES. GENERAL. SHOW SHEET CONDITIONAL

AND DO YOUR SENTENCE.

I ATACH A IMAGEN