topic Section Access Field wise in QlikView

Section Access Field wise

Mon, 29 Nov 2010 08:55:12 GMT

I have 3 users

Ranu

Chetan

rberi

I want to apply section access on the field level which is of name " Department " which has approx 290 codes.

Ranu wants to see 232 , 233 , 234, 235 ----- Departments

Rberi and chetan wants to see all 290 departments available .

Section access applied as followss ::::::

********************************************************************************************************

Load Upper(SHEETID) as SHEETID
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Sheet$);

Section Access;

Load upper([NTNAME]) as NTNAME,
upper([ACCESS]) as ACCESS,
'*' as SERIAL
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Access$);

concatenate

LOAD * INLINE [
ACCESS, NTNAME, SERIAL
ADMIN, *, Serial no
];

Join

LOAD
upper([NTNAME]) as NTNAME,
upper(DEPARTMENT) as [DEPARTMENT]
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Field$);

LOAD upper([NTNAME]) as NTNAME,
SHEETID
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Sheet$);
Section Application;
********************************************************************************************************

Attached is the section access which is used in code::::::

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7028.SectionAccess.xls:550:0]

NTNAME	DEPARTMENT
Ranu	232
ranu	233
ranu	234
ranu	235
chetan
rberi

NTNAME	ACCESS
Ranu	Admin
Chetan	Admin
rberi	Admin

NTNAME	SHEETID
ranu	SH01
ranu	SH02
ranu	SH03
chetan	SH01
chetan	SH02
chetan	SH03
rberi	SH01
rberi	SH02
rberi	SH03

Please suggest what changes should i do in the section access code ot the excel file so that i can give rberi and chetan full access to 290 departments

Section Access Field wise

Mon, 29 Nov 2010 09:09:34 GMT

Hi,

Use OMIT Command for restricting certain Owners and Leave blank for the owners to see all the departments

Regards

sunil

Section Access Field wise

Mon, 29 Nov 2010 09:19:33 GMT

Hi sunil

Can you please alaborate and help me where should i do the changes exactly .. please...

I have to give this thing by the end of day to client

Section Access Field wise

tresB — Mon, 29 Nov 2010 09:36:54 GMT

Hi Sir,

In section access if you use * then all the fields mentioned(included in section access) would be considered for the user. So if you use * here then only the four (132,233,234,235) departments would be available to the user. So what you have to do(i believe) add all the departments against those users in excel.

regards,

tresesco

Section Access Field wise

Mon, 29 Nov 2010 10:20:22 GMT

Dear tresesco

this is not a good option , adding 100 users with 290 department is no appriciable ,...

please suggest some other way

Section Access Field wise

Mon, 29 Nov 2010 11:07:12 GMT

Can Any body help me on this issueeeeee

PLzzzzzzzzzzzzzzzzzzzz

Section Access Field wise

Mon, 29 Nov 2010 14:22:47 GMT

no body have solution

Section Access Field wise

wizardo — Mon, 29 Nov 2010 18:22:02 GMT

you dont have to keep an excel file with the combination of 290 departments and 100 users, but you must read into the section access the whole values of department, so the users who has * will have them all. you can read it with a load from the database. or you can put the section access area after you have loaded the departments table and then read into the section access from memory.

section access area can put any where in the script (except before a binary statement)

Re: Section Access Field wise

Wed, 21 Mar 2012 08:26:36 GMT

MAY BE THIS ONE IS HELPFUL 4 U ......

Re: Section Access Field wise

SunilChauhan — Wed, 21 Mar 2012 08:55:39 GMT

try like below

section access;

Load * inline [

access,userid,password,OMIT

user,ranu,ranu,department

user,Chetan,Chetan,DEP

user,rberi,rberi,DEP

];

SECTION Application;

tab1:

Load * inline [

department

232

233

234

235

236

237

];

load

if(department=232 or department=233 or department=234 or department=235,department) as DEP,

department

resident tab1;

drop table tab1;

in document properties-> opening tab-> check iniatial data reduction based on section access and uncheck strict exclution

hope this helps