topic Section Access in QlikView

Section Access

kamalqlik — Tue, 17 Jan 2012 08:56:58 GMT

Hi friends,

I am using an application which contain the two fields such as.

I am having the field as

Region OTBranch

North Gurgaon

East Kolkata

West Bombay

South, Banglore

and so on.

What I want to do is that, I have to apply section access such as only the Person associted with that region can only see the data.

Thanks and regards

Kamal

Section Access

hic — Tue, 17 Jan 2012 13:21:23 GMT

There are many different ways to do this. I would probably make a Section Access with two tables:

Table1: REGION, QTBRANCH
Table2: NTNAME, ACCESS, QTBRANCH

and in the Section Application I would have a field REGION in some table. Then the person that logs on will be found in the NTNAME column, which links to QTBRANCH which in turn links to REGION.

Note that the linking field REGION (and its field values) must be all UPPER case.

/HIC