Section access issue

[#1]

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

[varunreddy]

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

[prabhu0505]

remove trim function and see.

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

[swuehl]

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.