topic Re: How to give access to different users to same qvw application in QlikView

How to give access to different users to same qvw application

Mon, 21 Oct 2013 08:31:07 GMT

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.

Re: How to give access to different users to same qvw application

marcus_sommer — Mon, 21 Oct 2013 08:40:05 GMT

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

Re: How to give access to different users to same qvw application

salto — Mon, 21 Oct 2013 08:41:11 GMT

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!

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 08:50:07 GMT

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.

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 08:51:12 GMT

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.

Re: How to give access to different users to same qvw application

marcus_sommer — Mon, 21 Oct 2013 08:54:30 GMT

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

- Marcus

Re: How to give access to different users to same qvw application

salto — Mon, 21 Oct 2013 09:03:50 GMT

Hi Amelia,

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

being your_user the username for you

HTH.

Re: How to give access to different users to same qvw application

amars — Mon, 21 Oct 2013 09:21:34 GMT

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...

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 09:24:39 GMT

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

Re: How to give access to different users to same qvw application

salto — Mon, 21 Oct 2013 09:26:10 GMT

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

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 09:30:23 GMT

Thanks very much.

Re: How to give access to different users to same qvw application

amars — Mon, 21 Oct 2013 09:31:25 GMT

As SALTO said Yes will need Document CAL's for each user. But for the developer no need of assigning an extra Doc CAL as the developer can always open it.

Thanks...

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 09:34:14 GMT

Another way around would be creating a Section Access Table inside your QVW. I think this option could be better in the long term since scalability will be much easier to handle, also you will reduce the amount of calculations in the front end.

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 09:36:47 GMT

Thanks and got it.

Re: How to give access to different users to same qvw application

salto — Mon, 21 Oct 2013 09:36:55 GMT

Hello,

If the goal is to hide data (and not objects) section access is the right approach. But as far as I know, the question was related to hide / unhide objects...

Regards!

Re: How to give access to different users to same qvw application

salto — Mon, 21 Oct 2013 09:38:11 GMT

Glad to know. Please mark the question as answered, it will help other users.

Regards!

Re: How to give access to different users to same qvw application

Mon, 21 Oct 2013 09:45:19 GMT

I was thinking in adding FLAG fields into the SA Table, so you can add visibility conditions inside the charts..

SA_Table Example:

ACCESS, USERID, FLAG_CHART1, FLAG_CHART2

USER, User1, 1, 0

USER, User2, 0, 1

If you apply data reduction to the Document, section access will allow you to control objects visibility without conditions. (Ex: Condition inside the chart --> FLAG_CHART1=1)