Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
RIGHT CLICK ON THE SPECIFIC SHEET GO TO PROPERTIES. GENERAL. SHOW SHEET CONDITIONAL
AND DO YOUR SENTENCE.
I ATACH A IMAGEN
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
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
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,
RIGHT CLICK ON THE SPECIFIC SHEET GO TO PROPERTIES. GENERAL. SHOW SHEET CONDITIONAL
AND DO YOUR SENTENCE.
I ATACH A IMAGEN