topic Condition to enable folder!!! in QlikView

Condition to enable folder!!!

Thu, 24 Sep 2009 20:56:34 GMT

Well, I have a .qvw, which has access control, each User enter your login and password, and only have access to their data, so far OK, my problem is that I have multiple folders, and only need to enable some folders. I saw it in the folder properties, there is a field to put a condition to enable the folder, I thought of putting any conditions on this site, but I can not think of a condition.
Can anyone help me?

Condition to enable folder!!!

Thu, 24 Sep 2009 21:43:25 GMT

Hi Evelyn,

a condition could be:

QVUSER() = 'rainer'

as example. QVUSER() is a system function.

Hope this helps!

Rainer

Condition to enable folder!!!

Thu, 24 Sep 2009 23:10:19 GMT

Ok
This worked in parts.
Consider:
I have several users, each accessing your information, your UserID and password, and I have a user Administrator, you access all the information.
These users, however, access some of the various folders that exist in my. Qvw, as the administrator has access to all folders.
As I have free access to someone my folders for these users? Does using this same function?

These are my users:

Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD, ACESSO
 ADMIN, TODOS, TODOS, ADMINISTRADOR
 USER, REPSP, REPSP, GRUPO1
 USER, REPREGSUL, REPREGSUL, GRUPO2
 USER, REPNORD, REPNORD, GRUPO4
 USER, REPRJ, REPRJ, GRUPO7
 USER, REPNORTE, REPNORTE, GRUPO9
];

Condition to enable folder!!!

GabrielAraya — Fri, 25 Sep 2009 00:25:45 GMT

Hi Evelyn, I did somothing similar time ago ... here is my solution:

In the Section Access:

Load * Inline [

ACCESS, USERID, GROUP

ADMIN, USER1, ALL

USER, USER2, G1

USER, USER2, G2

];

In the section application:

Load * Inline [

GROUP, Value

ALL, TAB1-TAB2-TAB3,TAB4

G1, TAB1-TAB4

G2, TAB1-TAB2

];

and each sheet properties, in Show Sheet - Conditional, I wrote the following instruction, by example:

index(Value,'Tab1') > 0

Condition to enable folder!!!

Fri, 25 Sep 2009 08:48:50 GMT

Thank you staff.
I ended up using the first form (QvUser () = 'Admin').
Used this condition in the folders that users do not have permission.

Tks