topic Re: Restricting users to see Sheet object in QlikView

Restricting users to see Sheet object

krishna20 — Mon, 14 Jul 2014 07:22:55 GMT

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

Re: Restricting users to see Sheet object

alexandros17 — Mon, 14 Jul 2014 07:26:30 GMT

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

Re: Restricting users to see Sheet object

ali_hijazi — Mon, 14 Jul 2014 07:28:01 GMT

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

Re: Restricting users to see Sheet object

krishna20 — Mon, 14 Jul 2014 07:32:21 GMT

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

Re: Restricting users to see Sheet object

hic — Mon, 14 Jul 2014 07:35:10 GMT

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

Re: Restricting users to see Sheet object

amit_saini — Mon, 14 Jul 2014 07:36:06 GMT

Kalyan,

Please follow these links:

Sheet level access

Thanks,
AS

Re: Restricting users to see Sheet object

Mon, 14 Jul 2014 07:44:40 GMT

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

Re: Restricting users to see Sheet object

krishna20 — Mon, 14 Jul 2014 09:02:35 GMT

Hi Pradeep,

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

Regards

Krishna

Re: Restricting users to see Sheet object

Mon, 14 Jul 2014 09:26:56 GMT

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

Re: Re: Restricting users to see Sheet object

krishna20 — Mon, 14 Jul 2014 09:39:17 GMT

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

Re: Re: Re: Restricting users to see Sheet object

Mon, 14 Jul 2014 10:31:00 GMT

Hi Kalyan,

Please find the attached .

Used Variable name as vUser. After Understanding delete the input box and apply "OSuser()" function in the variables.

Regards,

Pradeep

Re: Restricting users to see Sheet object

krishna20 — Tue, 15 Jul 2014 06:12:55 GMT

Hi Pradeep,

Thank you,the exact result i was expecting.

Is there any property to fill the place where the text objects are hiding.

I mean after hiding the text objects there is gap between two objects.Is there anyway to combine other text objects to fill that place automatically.

Regards

Krishna

Re: Restricting users to see Sheet object

Tue, 15 Jul 2014 06:22:51 GMT

Hi Kalyan,

Try by creating a Dummy Text objects in that place.

Even when unauthorized user click on that Dummy object. U might give some Error messages.

So that places won't be left blank.

Re: Restricting users to see Sheet object

krishna20 — Tue, 15 Jul 2014 06:25:44 GMT

Hi Pradeep,

We cant join the two displaying text objects to fill that space.?

Regards

Krishna

Re: Restricting users to see Sheet object

Tue, 15 Jul 2014 06:43:12 GMT

Hi Kalyan ,

We can by doing it give Layout layer to -1 or -2.

But the thing is as u say earlier, if there is user want to see two objects it will become issue.

So the better option is to create a dummy object mark it layer to -1 and keep it behind the original object.

So even when unauthorized user click on that he won't get any thing.

Re: Restricting users to see Sheet object

krishna20 — Tue, 15 Jul 2014 07:26:21 GMT

Hi Pradeep,

Thank You, If you dont mind can you pls give me example for this in my application which you have done yesterday.Because im new to Qlikview.

Regards

Krishna

Re: Re: Restricting users to see Sheet object

Tue, 15 Jul 2014 07:42:50 GMT

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

Re: Restricting users to see Sheet object

krishna20 — Tue, 15 Jul 2014 07:58:03 GMT

Thank You Very Much Pradeep