topic Re: Limit tab view based on user logon in QlikView

Limit tab view based on user logon

Anonymous — Mon, 01 Jun 2015 14:09:39 GMT

I know that you can limit the data a user can see by using the Section Access section of the script editor. I have used this successfully many times.

If you have a QlikView app with multiple tabs, can you limit the tabs a person can see based on their logon ID?

Has anyone ever done this?

Thanks,

Re: Limit tab view based on user logon

alexandros17 — Mon, 01 Jun 2015 14:11:34 GMT

In the conditional show of the tab make a comparison between your user (the one that has the pesmission to see the tab) and OSUSER()

Re: Limit tab view based on user logon

Mon, 01 Jun 2015 14:16:31 GMT

Yes, you have to use Sheet_ID instead of dimension in Section Access file.

Re: Limit tab view based on user logon

Anonymous — Mon, 01 Jun 2015 14:17:28 GMT

That is a good suggestion for a single user. The client I am working with wants to limit a fairly large group of people and wants the ability to change the access by updating an external file and reloading.

Re: Limit tab view based on user logon

Mon, 01 Jun 2015 14:19:57 GMT

You can maintain the login and sheet_id in external file like xls.

Ex:
LOAD
NTNAME,
SHEET_ID
FROM
[..\User_Access.xlsx]
(ooxml, embedded labels, table is Sheet1);

See if this works!!!

Re: Limit tab view based on user logon

b_garside — Mon, 01 Jun 2015 14:23:06 GMT

Basically you need to create a field in your Section Application code for determining what Tab should be hidden.

A Simple 1 / 0 binary will do then place that field. See below. I created a Field for each tab I wanted to be hidden for greatest control per user Role. ROLE will link the two tables together.

Section Access;

LOAD ACCESS,

USERID,

PASSWORD,

upper(NTNAME) as NTNAME,

ROLE

FROM

[Access_Control_List.xlsx]

(ooxml, embedded labels, table is Users);

Section Application;

LOAD

ROLE,

DASHBOARD,

MARKETS,

ACTIVEPIPE

FROM

[Access_Control_List.xlsx]

(ooxml, embedded labels, table is RoleAccess);

Re: Limit tab view based on user logon

awhitfield — Mon, 01 Jun 2015 14:25:34 GMT

Hi Ed,

you can make them conditional e.g using the OSUSer() function, =if(OSUser() = 'XXXXXI\YYYYYYYYYYY',1,0)

HTH Andy

Re: Limit tab view based on user logon

alexandros17 — Mon, 01 Jun 2015 14:29:33 GMT

use this expressionin the conditional section of the tab:

=Index(Upper(USERS), Upper(OSUser()))>0

Where USERS is a variable obtained doing a concat of all the users comeing from an Excel file (separated by a blank)

let me know

Re: Limit tab view based on user logon

jagan — Mon, 01 Jun 2015 14:30:23 GMT

Hi,

Try like this

Sheet level access

Regards,

Jagan.

Re: Limit tab view based on user logon

Anonymous — Mon, 01 Jun 2015 14:30:47 GMT

Thanks, Brian. That is what I was looking for.