topic Re: Section Access doubt in QlikView

Section Access doubt

gauthamchilled — Wed, 17 Jun 2015 01:27:39 GMT

Hi,

I have the following script for section access

Load

* Inline

[ACCESS,USERID,PASSWORD,REGION
ADMIN,ADMIN,ADMIN,*
USER,U1,Y1,AFRICA
USER,U2,Y2,AMERICA
USER,U3,Y3,ASIA
USER,U4,Y4,EUROPE
USER,U5,Y5,*]

;

Section

Application

;
SALES:
LOAD

* INLINE

[
REGION, PROFIT
AFRICA, 1000
AMERICA, 2000
ASIA, 3000
EUROPE, 4000
OCEANIA, 5000
]

;

If I am the user U1, i should see only Africa and profit of 1000. But when i log in as U1, i see everything. What is wrong here?

can any one help?

Re: Section Access doubt

Anonymous — Wed, 17 Jun 2015 01:36:31 GMT

Have you checked "initial data reduction..." on the "Opening" tab in the document properties?

Re: Section Access doubt

gauthamchilled — Wed, 17 Jun 2015 01:42:59 GMT

Great Micheal. That worked. Also if i close and re-open the document, it is not prompting me the user name and password. Is it because of caching. Is there anyway i can avoid this issue?

Re: Section Access doubt

Anonymous — Wed, 17 Jun 2015 01:46:45 GMT

Opt Initial Data Reduction it will work in document properties.

Hope it will helpful!!

Re: Section Access doubt

Anonymous — Wed, 17 Jun 2015 01:53:38 GMT

It is not cache. See "user preferences", uncheck "remember login credentials..."

Re: Section Access doubt

Siva_Sankar — Wed, 17 Jun 2015 05:47:57 GMT

Looks like you are trying section access first time, try reading a helpful document attached.

Re: Section Access doubt

gauthamchilled — Wed, 17 Jun 2015 05:54:55 GMT

Thanks.