Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
knightwriter
Contributor III

Section Access: All or Nothing

Hi all,

The section access (NTNAME) I currently have in place works when I open the qvw file on my computer.

When another user opens the file they get two options, they can see everything or get the error message "cannot access file".

What is the issue here?

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, CONSTRAIN1,

    ADMIN, EU\SAMPLE1, EU\SAMPLE1,

    ADMIN, EU\SAMPLE2, EU\SAMPLE2,

    USER, EU\SAMPLE3, EU\SAMPLE3,

];

Section Application;

zVisibility1:

Load [NTNAME] As CONSTRAIN1,

     [OWNER_PURCHASE] As "CAR_TYPE"

FROM (biff, embedded labels, table is [Visibility1$]);

Tags (1)
1 Solution

Accepted Solutions
knightwriter
Contributor III

Re: Section Access: All or Nothing

Hi Peter,

Thanks for the detailed note and I've seen a few posts on this issue but I cant understand whats changed in my script as it has worked ok before.

So, is this issue within the section application part? ie its cannot read as [OWNER_PURCHASE] As "CAR_TYPE"?

View solution in original post

12 Replies
Chanty4u
Esteemed Contributor III

Re: Section Access: All or Nothing

can u make it this  as    [CAR_TYPE]

Chanty4u
Esteemed Contributor III

Re: Section Access: All or Nothing

Re: Section Access: All or Nothing

(This only applies when opening your document in QV Desktop)

ADMIN users try to open a document with data reduction & strict exclusion, but the reduction reduces everything because of no valid link values = user can see everything. This is a Developer feature.

USER users try to open a document with data reduction & strict exclusion, but the reduction reduces everything because of no valid link values = user gets kicked out. If strict exclusion wouldn't be enabled, these users would see everything too.

Best,

Peter

Not applicable

Re: Section Access: All or Nothing

Try changing the script as per below example, the below code is working in my application.

section access;

LOAD * INLINE [

    ACCESS, USER, NTNAME

    ADMIN, A, NAM\A

    ADMIN, B, NAM\B

    USER, C, NAM\C

    USER, D, NAM\D

];

section application;

LOAD * INLINE [

    USER, Tab1, Tab2

    A, 1, 1

    B, 1, 1

    C, 1, 0

    D, 1, 0

knightwriter
Contributor III

Re: Section Access: All or Nothing

Hi Peter,

Thanks for the detailed note and I've seen a few posts on this issue but I cant understand whats changed in my script as it has worked ok before.

So, is this issue within the section application part? ie its cannot read as [OWNER_PURCHASE] As "CAR_TYPE"?

View solution in original post

Chanty4u
Esteemed Contributor III

Re: Section Access: All or Nothing

try dis

Load

UPPER [NTNAME] As CONSTRAIN1,

  UPPER [OWNER_PURCHASE] As [CAR_TYPE]

Chanty4u
Esteemed Contributor III

Re: Section Access: All or Nothing

issue found.

Load [NTNAME] As CONSTRAIN1,

     ([OWNER_PURCHASE]) As "CAR_TYPE"

or

Load [NTNAME] As CONSTRAIN1,

     ([OWNER_PURCHASE]) As [CAR_TYPE]

knightwriter
Contributor III

Re: Section Access: All or Nothing

Hi Chanty,

Thanks for the effort and I have changed the script.

Somewhat works as in some USERS still cannot access the file at all and other USERS can (with correct permissions).

Thoughts?

Chanty4u
Esteemed Contributor III

Re: Section Access: All or Nothing

that script is in  upper case and...reload the excel [access file]  and  chk it out.

NOTE:keep a copy of ur qvw.