How to give access to different users to same qvw application

[#1]

Hi,

I have one sales.qvw application with straight and pivot tables. I need to give access to sales.qvw file to users. But for user 1 one straight table, user 2 pivot table, user 3 pivot table and so on. How can I give access to different users to one sales.qvw so that they can able to see only their table. could anyone help me please.

Thanks.

[marcus_sommer]

If you want only to control the access from objects you could use osuser() in the visibility properties from these objects. If you need also to control the access to the data it could be solved with section access.

- Marcus

[salto · Accepted solution]

Hello,

QlikView objects can be shown to the users, or not, depending on the value of the "Show" property of the object.

In a Chart, you can find the "Show" property under the Layout tab.

It has two values: "Always" (all users can view the chart) or "Conditional".

In "Conditional" for the straight table , you can write something like match(upper(OSUser()),'user1')

In "Conditional" for the pivot table , you can write something like match(upper(OSUser()),'user2')

And so on!

[#4]

I just want to give access to objects which are reletaed to particular user. will it be possible. please let me know as I couldn't able to get this.

[#5]

Hi,

When I am giving match(upper(OSUser()),'user1') it is disabling the chart item and I am noe getting hoe to see that again.

[marcus_sommer]

You must set yourself also in these condition and then testing with various user logins.

- Marcus

[salto]

Hi Amelia,

yes, write match(upper(OSUser()),'user1','your_user')

being your_user the username for you

HTH.

[amars]

Hi,

To see the object again go to Settings -> Document Properties -> Sheets Tab -> Select the Sheet Name in which the report is placed. In the below list of Object you should be able to see the list of objects with ShowMode as Conditional:Hidden. Now click on the report name which you wish to grant access to -> Click Properties.

Now add your name to the list as well match(upper(OSUser()),'Domain\user1', 'Domain\user2', .....,'Domain\your_user'). Please make sure to include your Domain Name as well. For checking put OSUser() in a text box and check.

Thanks...

[#9]

Thanks but anyhow I have to assign three document CALs if I have three users. Is that correct? please let me know.

[salto]

Yes, the document CALs need to be assigned as well for every user that needs access to the document.