topic Re: Automatically unchecked Section access option in opening tab in QlikView

Automatically unchecked Section access option in opening tab

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Automatically unchecked Section access option in opening tab

shiveshsingh — Wed, 14 Mar 2018 17:47:15 GMT

Is it automatically get unchecked?

Re: Automatically unchecked Section access option in opening tab

Nagaraju_KCS — Wed, 14 Mar 2018 18:00:39 GMT

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.

Re: Automatically unchecked Section access option in opening tab

nihhalmca — Wed, 14 Mar 2018 18:03:37 GMT

Yes Shivesh.

Re: Automatically unchecked Section access option in opening tab

Chanty4u — Wed, 14 Mar 2018 18:03:42 GMT

Use always upper case for all script in section access

Re: Automatically unchecked Section access option in opening tab

nihhalmca — Wed, 14 Mar 2018 18:07:55 GMT

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.

Re: Automatically unchecked Section access option in opening tab

nihhalmca — Wed, 14 Mar 2018 18:08:46 GMT

Tried even not working.

Re: Automatically unchecked Section access option in opening tab

Chanty4u — Wed, 14 Mar 2018 18:11:34 GMT

may i know which version you are using?

Re: Automatically unchecked Section access option in opening tab

Chanty4u — Wed, 14 Mar 2018 18:12:01 GMT

its a bug in 11sr1 version check this disuusion

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

Re: Automatically unchecked Section access option in opening tab

Nagaraju_KCS — Wed, 14 Mar 2018 18:28:54 GMT

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.

Re: Automatically unchecked Section access option in opening tab

shiveshsingh — Thu, 15 Mar 2018 05:39:23 GMT

I am not sure but i didn't face this issue while using your code... which version you are using?

Re: Automatically unchecked Section access option in opening tab

nihhalmca — Mon, 19 Mar 2018 13:00:51 GMT

QlikView Desktop 11.

Can you share your document please.

Re: Automatically unchecked Section access option in opening tab

nihhalmca — Mon, 19 Mar 2018 13:02:14 GMT

Can you share your document please.