Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Sheet visability

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

1 Solution

Accepted Solutions
fdelacal
Not applicable

Re: Sheet visability

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

AND DO YOUR SENTENCE.

I ATACH A IMAGEN

4 Replies
fdelacal
Not applicable

Re: Sheet visability

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

Not applicable

Re: Sheet visability

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

Not applicable

Re: Sheet visability

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,

fdelacal
Not applicable

Re: Sheet visability

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

AND DO YOUR SENTENCE.

I ATACH A IMAGEN