topic Section Access: All or Nothing in QlikView

Section Access: All or Nothing

knightwriter — Wed, 25 Nov 2020 16:16:04 GMT

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$]);

Re: Section Access: All or Nothing

Chanty4u — Thu, 03 Mar 2016 09:37:59 GMT

can u make it this as [CAR_TYPE]

Re: Section Access: All or Nothing

Chanty4u — Thu, 03 Mar 2016 09:39:18 GMT

chk dis

Section Access (English)

Re: Section Access: All or Nothing

Peter_Cammaert — Thu, 03 Mar 2016 09:39:47 GMT

(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

Re: Section Access: All or Nothing

Thu, 03 Mar 2016 09:45:09 GMT

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

Re: Section Access: All or Nothing

knightwriter — Thu, 03 Mar 2016 10:04:17 GMT

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

Re: Section Access: All or Nothing

Chanty4u — Thu, 03 Mar 2016 10:21:59 GMT

try dis

Load

UPPER [NTNAME] As CONSTRAIN1,

UPPER [OWNER_PURCHASE] As [CAR_TYPE]

Re: Section Access: All or Nothing

Chanty4u — Thu, 03 Mar 2016 10:24:41 GMT

issue found.

Load [NTNAME] As CONSTRAIN1,

([OWNER_PURCHASE]) As "CAR_TYPE"

Load [NTNAME] As CONSTRAIN1,

([OWNER_PURCHASE]) As [CAR_TYPE]

Re: Section Access: All or Nothing

knightwriter — Thu, 03 Mar 2016 10:54:03 GMT

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?

Re: Section Access: All or Nothing

Chanty4u — Thu, 03 Mar 2016 10:57:52 GMT

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

NOTE:keep a copy of ur qvw.

Re: Section Access: All or Nothing

Peter_Cammaert — Thu, 03 Mar 2016 11:06:15 GMT

There have been a lot of useful suggestions that boil down to this: your script may be the same as before, but the data may be different. And your script suddenly proves incapable of doing the right thing in all situations.

Use the suggestion on UPPER() at all times when dealing with Section Access and link values.

Re: Section Access: All or Nothing

knightwriter — Thu, 03 Mar 2016 13:10:44 GMT

Hi,

Thanks both for your inputs, both educating and helpful.

Re: Section Access: All or Nothing

knightwriter — Fri, 04 Mar 2016 10:36:01 GMT

Hi Peter / Chanty,

Upon reload this morning, the same users now cannot get access the qvw.

I had made a couple of small changes yesterday with the advise from above which was successful as users could then access the file. So strange and frustrating.

Does the script pick up a space as an extra character as excel does? so in my script I have USER," SAMPLE1" but in the excel doc its "SAMPLE1" (ie no space before the S in the excel cell).

Im at a loss and that's the only thing I can think of.