topic Section Access Help in QlikView

Section Access Help

Tue, 02 Aug 2011 16:53:46 GMT

Hello Everyone,

I am having an issue implementing section access so that QV reduces the data based on the field I specified in the section access code.

Here is the section access code I put in the load script:

Section

Access;
LOAD * INLINE [
    ACCESS, NTNAME, HOSPITAL
    USER, USER, HOSPITAL 1
    USER, USER1
    USER, USER2
    ADMIN, ADMIN
    ADMIN, ADMIN1
    ADMIN, DFWHC\WAVETWO2
];
Section Application;

I want certain users to only see their hospital, while allowing other users to see all hospitals. The section access is working in the sense that unauthorized users cannot open the document; however, QV is not reducing the data at all. If I sign in as "USER", I am able to see all the hospitals rather than just HOSPITAL 1. Help!!

Section Access Help

Wed, 03 Aug 2011 01:34:14 GMT

Hi ,

Can you give me any sample code or breif explaination that where you are trying to reduce the data . & how ,

so if i know anything that's going i can help you

thanks

Meher

Re: Section Access Help

Wed, 03 Aug 2011 02:29:23 GMT

Hi,

Along with Section Access code you added in script, you need to set an option of "Initial Data Reduction Based on Section Access" checked from

Menu - > Settings -> Document Properties -> Opening tab.

Please see the attached sample.

Cheers.