section access

[alexpanjhc]

Hi

I am having some trouble in section access.

here is the code I used

section Access;

star is *;

LOAD upper(ACCESS) as ACCESS,

  upper(USER)  as USER,

     upper([Sales Office])  as [Sales Office]

FROM



(ooxml, embedded labels, table is Sheet1);



section Application;

I also ticked the initial data redection based on section access, strick exclusion is checked too.(see attached)

when I closed out the qlikview and open it again, I did not asked to provide user name and password.

What was the problem?

Thanks

[#2 · Accepted solution]

Hi,

Try :

  upper(USER)  as USERID,

Regards,

Yigal.