topic Re: section access 'All' or '*' in QlikView

section access 'All' or '*'

vardhancse — Fri, 10 Feb 2017 07:47:28 GMT

Hi,

As part of section access field level authorization:

SECTION ACCESS;

Access:

LOAD ACCESS,

NTNAME

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Access);

SECTION Application;

Security:

LOAD NTNAME,

NAME

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Security);

As per the given excel sheet every thing was fine,

Field level security was working perfectly. But the issue was if I give * for the NAME field

Then, Its not showing any thing, can please let me know any alternative for the same

Chanty4u — Fri, 10 Feb 2017 07:51:09 GMT

Hi,

did you checked this ?

avinashelite — Fri, 10 Feb 2017 07:54:37 GMT

Add this statement after section application;

star is *;

pokassov — Fri, 10 Feb 2017 07:59:49 GMT

Hello!

If you want to give access to everyone by using "*" why would you just comment your Section Access block?

vardhancse — Fri, 10 Feb 2017 08:15:09 GMT

We have around 100 users, not all users are * access only very few.

vardhancse — Fri, 10 Feb 2017 08:19:56 GMT

Hi,

* means all the listed values or else all the values in the field?

From QlikView help its saying that: