topic Re: Section access issue in QlikView

Section access issue

Tue, 27 Oct 2015 20:34:49 GMT

Hi,

I have tried to implemented section access in a Qlikview file. I have used the below script

Section Access;
LOAD ACCESS, 
     USERID, 
     PASSWORD,
//     USERLINK,
//     [Business Entity]
     trim([Business Entity])&'|'& trim([Business Unit]) as [REDUCTION FIELD]
 //    LEVEL
FROM
$(_Config_Path)User Security.xlsx
(ooxml, embedded labels, table is Users);

SECTION Application;

In the data, I have used the below code

Employees:
LOAD [Employee Name] As [Employee Name], 
     [Employee ID], 
     [Email Address], 
     Country, 
     [BI Manager],
     trim([Org Unit 1 - Name])&'|'& trim([Org Unit 2 - Name]) as [REDUCTION FIELD]
FROM
$(_Extract_QVD_Path)Employees.qvd
(qvd);

There is a user called john who has been allowed two different business units.

As you can see in the attached image, if I click on user john, I can see few rows. I am expecting that when I use section access, user john should be able to see these rows. However, in reality when I use the user john to see the data, I get an error message that the user does not have access to the document

Can someone please guide me what could be wrong with my section access

Regards

Shah

Re: Section access issue

varunreddy — Tue, 27 Oct 2015 20:44:29 GMT

Hi Syed,

Try this :

Access UserId Password [Reduction Field]

User xyz xyz *

Hope this hepls. Here we are giving access to all the values in [Reduction Field]

Regards,

Varun

Re: Section access issue

prabhu0505 — Tue, 27 Oct 2015 21:24:52 GMT

remove trim function and see.

[Business Entity]&'|'&[Business Unit] as [REDUCTION FIELD]

Re: Section access issue

swuehl — Tue, 27 Oct 2015 21:31:00 GMT

FROM HELP:

Note!
All field names used in the transfer described above and all field values in these fields must be upper case, since all field names and field values are by default converted to upper case in section access.