Automatically unchecked Section access option in opening tab

[nihhalmca]

Hi All,

I am trying below section access code however automatically unchecked Initial data reduction based on section access option at opening tab (Document properties).

Followed below setps:

1. Copied this code in QVW

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    ADMIN, A

    USER, B

    USER, C

    USER, D

];

Section Application;

Table:

LOAD * Inline [

USERID,Sheet1,Sheet2

A,1,1

B,0,1

C,1,0

];

2. checked Initial data reduction based on section access option at opening tab (Document properties) and clicked apply and ok.

3. Then after reload or below reload qvw if i see section access option at opening tab its unchecked why? what i missed here.

Thanks

Nihhal.

[shiveshsingh]

Is it automatically get unchecked?

[qv_testing]

Field names are should be UPPER case. please make sure all the values UPPER case.

Whenever you use INLINE table qlikview implicitly takes the Section Access in to UPPER case.

Make it UPPER and Try once.

[nihhalmca]

Yes Shivesh.

[Chanty4u]

Use always upper case for all script in section access

[nihhalmca]

Hi Raju - Actually Common field should be upper i already made it, you can see at question.

Moreover i tried as you said, no luck.

[nihhalmca]

Tried even not working.

[Chanty4u]

may i know which version you are using?

[Chanty4u]

its a bug in 11sr1 version  check this disuusion

Security Failure QV11 SR1 - Initial Data reduct... | Qlik Community

[qv_testing]

This code is working for me,

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    ADMIN, A

    ADMIN, B

    ADMIN, C

];

Section Application;

Table:

LOAD * Inline [

USERID,SH01,SH02

A,1,1

B,0,1

C,1,0

];

May be QV Version problem, not sure.