topic Re: restricting access in an app in QlikView

restricting access in an app

Fri, 25 Sep 2015 07:26:10 GMT

Hi,

In one of our apps there is a sheet which includes a few charts and tables (with subsequent calculation expressions). It has some confidential information on cost that I don't want my team to see (it would reveal salaries). Want to avoid creating a copy which I would save in my personal drives so want to see what options are available.

As a result, can you block/restrict:

1) a sheet

2) an expression

3) a chart

Any help would be appreciated.

Chris

Re: restricting access in an app

jonathandienst — Fri, 25 Sep 2015 07:34:43 GMT

Check the OMIT keyword in the section access part of the manual, or search here. OMIT provides column level security.

Re: restricting access in an app

jonathandienst — Fri, 25 Sep 2015 07:38:25 GMT

Re: restricting access in an app

Peter_Cammaert — Fri, 25 Sep 2015 11:48:22 GMT

Sheets, Expressions and Charts (& objects in general) all have a property called "Conditional Show". It lets you show/hide objects based on the outcome of an expression. That expression can be tied to Section Access.

See here for examples: Type of Security

In the community, there are many more discussions on this topic

Re: restricting access in an app

hic — Fri, 25 Sep 2015 12:02:24 GMT

You should look at Section Access. See A Primer on Section Access.

But it is not a good idea to hide objects. These are just "windows" to the information behind, and in order to make this scheme work you have to make sure that all relevant objects are hidden and that it is not possible for the user to create additional objects. A better way is to hide the information itself, which you can do through Section Access. In your case you should use OMIT.

See also Data Reduction – Yes, but How?

HIC

Re: restricting access in an app

Fri, 25 Sep 2015 12:07:50 GMT

you can use section access if a user needs access to a sheet but the data they see needs to be limited.

If you only want certain users to see/not see sheets in their entirety, the easisiest way is to use a conditional on the sheet with the condition as =UPPER(OSuser())='domain name\user name - this will allow only the users listed to see the tab (you can us 'or' to repeat the upper comman for multiple users

Re: restricting access in an app

Tue, 06 Oct 2015 10:18:32 GMT

I tried this using your code and the sheet has gone but the plan is I should see it. The expression I have put in is:

=UPPER(OSuser())='citywest\chris.fray

is citywest the domian name?

Chris