Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access Help

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

2 Replies
Not applicable
Author

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

Not applicable
Author

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.