Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator 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$]);

1 Solution

Accepted Solutions
knightwriter
Creator III
Creator III
Author

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
MVP
MVP

can u make it this  as    [CAR_TYPE]

Peter_Cammaert
Partner - Champion III
Partner - Champion III

(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

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
Creator III
Creator III
Author

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"?

Chanty4u
MVP
MVP

try dis

Load

UPPER [NTNAME] As CONSTRAIN1,

  UPPER [OWNER_PURCHASE] As [CAR_TYPE]

Chanty4u
MVP
MVP

issue found.

Load [NTNAME] As CONSTRAIN1,

     ([OWNER_PURCHASE]) As "CAR_TYPE"

or

Load [NTNAME] As CONSTRAIN1,

     ([OWNER_PURCHASE]) As [CAR_TYPE]

knightwriter
Creator III
Creator III
Author

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
MVP
MVP

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

NOTE:keep a copy of ur qvw.