topic Section Access in QlikView

Section Access

Thu, 04 Oct 2012 10:56:51 GMT

Hi All, if you can help please let me know...

I want to use section access on a document based on the below criteria but I can't get it working

User 1 can access Region = '1'

but User 2 should be able to access Region = '1' but Country 'France'

How do i achieve this in section access.

Your help would be greatly appreciated

hic — Thu, 04 Oct 2012 12:27:41 GMT

You need to use some way to denote all countries in your authorization table. One way to do this is described on http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

HIC

SunilChauhan — Thu, 04 Oct 2012 12:42:07 GMT

use below code for example

section access;

Load * inline [

Access,UserID,REGION

Admin,121,

User,122,2

];

SECTION Application;

Load * inline [

REGION,Country

1,France

2,US

];

go to document properties->Opening _> Initial data reduction based on section access

see the attached file

user ID's 121 and 122

hope this helps

Thu, 04 Oct 2012 13:29:36 GMT

Works a treat 😉 Thanks