topic Re: Confused: section access and section application in QlikView

Confused: section access and section application

Fri, 23 Mar 2012 07:27:52 GMT

Hi There,

I am new on QlikView. Did check some of the documents but no help.

I want to use the section access to control the users to see the data in their own configuration. There is a dimension named CONFIG_ITEM_DESCRIPTION, I want to restrict use to read data in their own config item, the following code as you can see. I want the user U2 to only see the data in ConfigU2.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, Bruce, Bruce

USER, U2, U2

USER, U3, U3

];

Section Application;

LOAD * INLINE [

USERID, CONFIG_ITEM_DESCRIPTION

U2, ConfigU2

U3, ConfigU3

];

But after I implemented this, and deployed on server. I even cannot login with the user name and password then.

Anyone can help?

Confused: section access and section application

Fri, 23 Mar 2012 07:57:08 GMT

I use the QlikView 10

Re: Confused: section access and section application

SunilChauhan — Fri, 23 Mar 2012 07:58:26 GMT

in document properties -> opening -> initial data reduction based on section access (check it )

see the attched file hopw this helps you

Re: Confused: section access and section application

Fri, 23 Mar 2012 08:11:27 GMT

I did check the item. it doesn't work.

But you attachment is good to me, I will investigate it. thanks

Re: Confused: section access and section application

Fri, 23 Mar 2012 09:10:57 GMT

And additionally, The

CONFIG_ITEM_DESCRIPTION is a dimenssion loaded from a database.

Re: Confused: section access and section application

SunilChauhan — Fri, 23 Mar 2012 09:49:35 GMT

did got your solution or you want any thing else