Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Restricting users to see Sheet object

Hi Friends,

In my Dashboard,i'm using Text object as Tabs.Like HOME,Underwriting,CLAIMS,REINSURANCE,,,..

I need to show the all the tabs to ADMIN.

For USER1 UnderWriting and CLAIMS,

For USER2 CLAMS and REINSURACE,

FOR USER3 REINSURANCE and Underwriting.

I attached Image of my dashboard.Can Any one pls help me out how can i restrict it and need coding for this.I'm new to this concept.

Regards

Krishna

1 Solution

Accepted Solutions
Not applicable

Kalyan,

Please find the attached .

and kindly close the thread my marking helpfull or correct answer. so that it will usefull for others.

Regards,

Pradeep

View solution in original post

17 Replies
alexandros17
Partner - Champion III
Partner - Champion III

The easiest way to do this is with OSUSER() instruction.

In each sheet you have to set the visibility condition to OSUSER()=youruser

Let me know

ali_hijazi
Partner - Master II
Partner - Master II

in the properties of each sheet , go to General->Show Sheet, select the Conditional radio button

in the text box

use something like

if(match,OSUser(), ADMIN,USER1,1,0)

this means on this sheet it is visible to users Admin, and User1 (OSuser() returns the user name in the following format : domain\user_name

then in the document properties Settings->Document Properties-> check the Hide Tabrow checkbox

in the actions of your text box select Layout->Activate sheet-> put the id of the sheet

I can walk on water when it freezes
krishna20
Specialist II
Specialist II
Author

Hi Ali,

I dont want that the user should not see this Text Objects when s/he login.

I mean to say Admin can see all the text boxes,

User can see only the text boxes which we assigned to them.I want to filter the Text Objects in main page itself.

Regards

Krishna

hic
Former Employee
Former Employee

Using OSUser() to hide objects will work.

But - just to be clear: This is a lousy method to achieve security. If the goal is security, then you should choose another method (in addition). See more on Data Reduction – Yes, but How?

HIC

amit_saini
Master III
Master III

Kalyan,

Please follow these links:

Sheet level access

Thanks,
AS

Not applicable

Hi,

Create one variable with name  "=osuser" as value.

Then in the textbox in the Layout Tab. on Conditional show give the created variable is equal to 'ADMIN'.

=OSuser() = 'ADMIN' . If it is not admin then it will not the text object.

Hope this help

With Regards

krishna20
Specialist II
Specialist II
Author

Hi Pradeep,

If i use the above condition,text object is hiding automatically.

Regards

Krishna

Not applicable

Hi Kalyan,

If you use the above condition.


Text object will be visible only when your user name = 'ADMIN'

so if the user name is  USER 1 then USER 1 = Admin (False)   - - - >Hide the Text object

if user name is ADMIN then ADMIN  =ADMIN (True) - -> Enable the Text object.

PS: If you want to visible the hide object manually then GOTO

Settings --->Sheet properties ---->objects -----> "Your Object" ------> Properties -------> Enable.

if it is still confusing please attach a sample file.

Thanks,

Pradeep

krishna20
Specialist II
Specialist II
Author

Hi Pradeep

Please find the attachment and let me know how can i do it.Please highlight where u have done changes through screen shots.It will be helpful for me.

Regards

Krishna