Section Access

[#1]

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]

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 · Accepted solution]

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

[#4]

Works a treat 😉 Thanks