Section Access for hiding objects

Tue, 17 Nov 2009 00:15:30 GMT

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.

Section Access for hiding objects

Tue, 17 Nov 2009 14:11:03 GMT

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 ...

topic Section Access for hiding objects in QlikView

Section Access for hiding objects

Section Access for hiding objects