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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access only work after open the document

Hi,

I am new user and work with QlikView Personal 11 SR1.

I try to understand the section access with relationship to section application.

This is my script:

 

SECTION Access;
LOAD * Inline
[ACCESS, USERID, PASSWORD, WERKS
ADMIN,A,A,*
USER,U10,U10,DE10
USER,U15,U15,DE15];

SECTION Application;

STOCK:
SELECT
    X.BUKRS BUKRS,
    X.WERKS WERKS,
    X.MATNR MATNR,
    X.MENGE_AME MENGE_AME
FROM
    SBTABLES.SB_BESTAND X
WHERE
    WDATE = '2012.08.31';

When I open the document with user U10 and password U10, I only see the values for WERKS = DE10.

But when I press the reload button, I see all values.

my Section Access on document level ( all checked )

- Initial Data Reduction Based on Section Access

- Strict Exclusion

- Prohibit Binary Load

What is wrong ?

Holger

Labels (1)
0 Replies