Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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