Section Access for hiding objects

[#1]

Hi,

I am looking to use 'Section Access' to restrict user access in my application. I want each user to see only those portion of object which is based on 'City', i.e. each manager of each city will see only his city data after opening the file. I tried below section access code to do so, but it is not coming out.

Section

Access;

LOAD

[USERID]

,

[PASSWORD]

,

[ACCESS]

FROM

(

txt, codepage is 1252, embedded labels, delimiter is ',', msq)

;

LOAD

[USERID]

,

CITY

FROM

(

txt, codepage is 1252, embedded labels, delimiter is ',', msq)

;

Section

Application;

Directory;

LOAD

City,

Membership

FROM

(

txt, codepage is 1252, embedded labels, delimiter is ',', msq)

;

Attached are the CSVs and QlikView in winzipped file for more clarification.

Please suggest a step by step process to achieve it.Thanks.

[#2]

Rename City in your section application as CITY after using Upper() for the same.

The Code should be

section application ;

LOAD

UPPER(City) as CITY,

Membership

FROM ...