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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Confused: section access and section application

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?

5 Replies
Not applicable
Author

I use the QlikView 10

SunilChauhan
Champion II
Champion II

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

see the attched file hopw this helps you

Sunil Chauhan
Not applicable
Author

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

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

Not applicable
Author

And additionally, The

CONFIG_ITEM_DESCRIPTION is a dimenssion loaded from a database.

SunilChauhan
Champion II
Champion II

did got your solution or you want any thing else

Sunil Chauhan