reduce data by user using section access

Fri, 11 Oct 2013 05:33:46 GMT

Hi all,

i encounter a problem when edit sectoin access. My goal is : USER1 can see the data from Area 'A' and USER2 can see the data of Brand 'X'. That's to say, USER1 reduce data by only field 'Area' no matter other fields are listed in the section access .

I did a test like below:

section access;

load * inline

[ACCESS,USERID,PASSWORD,%AREA,%BRAND

ADMIN,USER0,123

USER,USER1,123,A,*

USER,USER0,123,*,X

];

section application;

Sales:

load * inline [

Area,Brand,Sales

A,X,10

A,Y,20

B,X,30

B,Y,40

];

left join (Sales)

LOAD * inline

[Brand,%BRAND

X,X

Y,Y

];

LEFT JOIN (Sales)

load * inline

[Area,%AREA

A,A

B,B

];

the result is : Both USER1 and USER2 see the data of Brand X in area A .

Thanks

Zhou

Re: reduce data by user using section access

Gysbert_Wassenaar — Fri, 11 Oct 2013 07:08:26 GMT

See this blog post for how to deal with such OR constructions: Basics for complex authorization

Re: reduce data by user using section access

Fri, 11 Oct 2013 07:42:28 GMT

you're great !

topic Re: reduce data by user using section access in QlikView

reduce data by user using section access

Re: reduce data by user using section access

Re: reduce data by user using section access