topic Security on a Qlikview file in QlikView

Security on a Qlikview file

Thu, 05 Nov 2009 00:22:43 GMT

Hi All

I've been reading the posts on here about the qlikview security which you can setup with scripting. I've managed to set up a number of user accounts...yey.

One problem i am reaching is that i would like certain sheets to be either accessable or not depending on which user logs in. Also i have some buttons which link to other Qlikview files which i would like to make inactive depending on the user who sign on.

Is this possible to do or can i only restrict on a column/row basis?

Thanks

Michel

Security on a Qlikview file

Oleg_Troyansky — Thu, 05 Nov 2009 00:41:08 GMT

Each object in QlikView has a "Show Condition" ( the setting is located on the layout tab). Using Show Condition, you can hide certain objects - charts, buttons and even whole sheets, based on the User or User-related settings (groups, roles, etc...)

cheers,

Security on a Qlikview file

Thu, 05 Nov 2009 17:44:37 GMT

Thank you for the info:

Following some other posts on the forum i've loaded the following code:


Section Acess;
ACCESS, USERID, PASSWORD, USERGROUP
ADMIN, Admin, , Admin
USER, USER1, USER1, G1

USER, USER1, USER1, G2




];
Section Application;
LOAD * INLINE[
USERGROUP, FLAG
ADMIN, 0
G1, 1
G2,2
];

This seems to work in the sence that the flag will hide and show perticular sheets. But the problem i am having is when a user logs in the flag selection does not seem to be selected. Is there something wrong with my user load section of the script?

Thanks

Michel