Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
Try setting it like:
Star is *;
Thanks but when I select the field REDUCTION is still only shows *
Your section access should have REDUCTION field too and that is where you should use '*' (not in the application section).
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;
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.
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.
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.
Hi Daniel,
I attached the sample script in that thread in my previous post. Please check .
Regards,
Jagan.