topic Re: Field not Found when Adding Section Access in QlikView

Field not Found when Adding Section Access

cranium144 — Wed, 21 Jan 2015 14:26:54 GMT

I have dashboard that has been auto-reloading just fine for a over a month. I am attempting to make it so only select users can see the dashboard in the Access Point. I believe I should do this via Section access. So I created a hidden script (below). When I do a reload it gives me the Field not Found error on the very first field to load on the next tab. When I remove the hidden script, it works just fine.

Section Access;

Access01:

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, DILLACP\CLAYB

USER, DILLACP\SMITHB

];

Re: Field not Found when Adding Section Access

rwunderlich — Wed, 21 Jan 2015 14:37:18 GMT

Do you have a "SECTION Application" statement following your Section Access load?

-Rob

Re: Field not Found when Adding Section Access

cranium144 — Wed, 21 Jan 2015 14:39:52 GMT

I do not in this dashboard. I don’t want to limit the data that can be seen. I just want to limit who can see that it exists to the people that can use it.

Re: Field not Found when Adding Section Access

Anonymous — Wed, 21 Jan 2015 14:47:49 GMT

still you need to have the 'Section Application;' like below code

Section Access;

Access01:

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, DILLACP\CLAYB

USER, DILLACP\SMITHB

];

Section Application;

//then load your other regular tables

Re: Field not Found when Adding Section Access

tcullinane — Wed, 21 Jan 2015 14:55:16 GMT

In the QMC task reload change the distribution to only the relevant users.

or if by dashboard you mean a single tab in an application you could use the sheet properties 'show sheet' as conditional on

=Wildmatch(OSUser(), '*CLAYB*','*SMITHB*')