Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Re: Section Access

OK can you please post your section application code...

FYI:

section will control the access to the document , data access will be taken care in section application code, we are miss that here, please post that.

Re: Section Access

Hi,

If you want to give domainname\peterz all access change it ACCESS from USER to ADMIN.

Regards

Regards,
Prashant Sangle
Employee
Employee

Re: Section Access

The position of the reduction field does not matter. However, if you have multiple reduction fields there is an increased risk that you have not predicted the outcome correctly.

Also keep in mind that the reduction values must be in upper case, in both the reduction field in section access table and in the data table.

rido1421
Contributor II

Re: Section Access

Hi Toni

From What I have read on previous posts, the Lower case and upper case make a difference when loading from QVD... There are many users so im just afraid how long it will take for me to change to upper case... Do you think it will definitely have an impact?

Thank you I was not aware what * meant I thought it means all data.

is <ALL Values> a system field?

Thanks you.

rido1421
Contributor II

Re: Section Access

Hi Avinash

That was my initial script...

Employee
Employee

Re: Section Access

I doubt that you have so many users in the QVD that it will make a significant performance difference.

<All VALUES> is just a syntax I commonly use to indicate that I expect to get all values. To me this signals a clear intention with the reduction value, compared to leaving the field blank. If you accidentally load a blank value, the blank field would not represent all, but the actual blank value.

This is an effect of how the reduction value is applied. See my post on Section Access: Strict Exclusion for an example of why an non-existing value returns all values.

Re: Section Access

OK try something like this:

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,*,*
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

];

section application;

Load * inline

[

NTNAME,COST_CENTRE, CODE_2

DOMAINNAME\Johna , *, A12
domainname\peterz ,*,*
domainname\paulo ,*,*

domainname\kevinw , 2101,*

];

Re: Section Access

refer this document

vinay_hg
Contributor II

Re: Section Access

check is data splitted properly across your section access condition. i mean there should not be any left out data which will not match any of scetion access data. and also check is there any null values in the section access given data.in your case that must be cost center and code_2

Highlighted
rido1421
Contributor II

Re: Section Access

Thank you this seems to work really well.

I am still testing it . but it seems to be working correctly