topic Re: Section access wild card in QlikView

Section access wild card

Daniel_Moore — Mon, 26 Jan 2026 18:19:17 GMT

I'm trying to do a simple row level section access. It seems to work for users, but I am trying to use wildcards for admins, so they can see all accounts. Unfortunately when I use the wildcard it's treated the same as any other text value - so it is looking for the REDUCTION called * and not finding any in the data.

How do let QV know I'm looking ANYTHING not just something called *?

Section Access;

LOAD USERID,
'*' as PASSWORD,
ACCESS
FROM
Visibility.qvd
(qvd) WHERE 1=1;

SECTION APPLICATION;

LOAD USERID,
REDUCTION
FROM
Visibility.qvd
(qvd) WHERE 1=1;

Re: Section access wild card

tresB — Tue, 02 Sep 2014 04:58:05 GMT

Try setting it like:

Star is *;

Re: Section access wild card

Daniel_Moore — Tue, 02 Sep 2014 05:10:41 GMT

Thanks but when I select the field REDUCTION is still only shows *

Re: Section access wild card

tresB — Tue, 02 Sep 2014 05:14:46 GMT

Your section access should have REDUCTION field too and that is where you should use '*' (not in the application section).

Re: Section access wild card

Daniel_Moore — Tue, 02 Sep 2014 05:43:54 GMT

Really good

I can now see all rows as admin.

> and that is where you should use '*' (not in the application section).

Not sure what you mean about this part of your answer - I have REDUCTION being loaded in both sections, and it seems to work?

Section Access;

LOAD USERID,
'*' as PASSWORD,

ACCESS,

REDUCTION
FROM
Visibility.qvd
(qvd) WHERE

1=1;

SECTION APPLICATION;

LOAD USERID,
REDUCTION
FROM
Visibility.qvd
(qvd) WHERE 1=1;

Re: Section access wild card

jagan — Tue, 02 Sep 2014 05:52:14 GMT

Hi,

Check this link, hope it helps you.

Authentication and Authorization in Qlikview

Sample Script:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept,

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

Regards,

jagan.

Re: Section access wild card

tresB — Tue, 02 Sep 2014 05:52:25 GMT

Yes it has to be there in both sections. Only point to note is, the '*' is supposed to be used in section access which would effectively mean all values mentioned in section access REDUCTION field.

Re: Section access wild card

Daniel_Moore — Tue, 02 Sep 2014 06:02:47 GMT

Jagan, Has the URL been updated? When I tried to access your link I got:

Unauthorized

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

Re: Section access wild card

jagan — Tue, 02 Sep 2014 06:05:49 GMT

Hi Daniel,

I attached the sample script in that thread in my previous post. Please check .

Regards,

Jagan.