Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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

AND DO YOUR SENTENCE.

I ATACH A IMAGEN

View solution in original post

4 Replies
fdelacal
Specialist
Specialist

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
Author

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
Author

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
Specialist
Specialist

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

AND DO YOUR SENTENCE.

I ATACH A IMAGEN