Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jaarroyl
New Contributor III

how to hide sheets according to the kind of user

Good morning, i want to know how could i hide sheets according to the kind of user.

I have this users:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    admin, jarroyo, 101910

    user, egomez,

    user, cquiroz,

    user, rdelcampo,

    user, jbecerra,

    user, jtorres

    user, apanes

    user, rgarcia

    user, invitado

    user, jlopez

    user, pmuirhead

];

Section Application;

I have created an variable to input the conditional, but It doesn work.

I just want to show the "resumen" sheet only for this users.

=vUsuario='jarroyo' or 'rdelcampo' or 'pmuirhead'

Tags (2)
1 Solution

Accepted Solutions

Re: how to hide sheets according to the kind of user

Try this in sheet level from General enable of condition.

If(Match(QVUSER(), 'jarroyo', 'rdelcampo', 'pmuirhead'), 1, 0)

Life is so rich, and we need to respect to the life !!!
5 Replies

Re: how to hide sheets according to the kind of user

Try this in sheet level from General enable of condition.

If(Match(QVUSER(), 'jarroyo', 'rdelcampo', 'pmuirhead'), 1, 0)

Life is so rich, and we need to respect to the life !!!
jaarroyl
New Contributor III

Re: how to hide sheets according to the kind of user

I've done that. I sing up with jarroyo and I cant see the sheets anymore.

How could I go back?

Thanks

jaarroyl
New Contributor III

Re: how to hide sheets according to the kind of user

It works, but the user had to be on UPPER.

THANKS FOR ALL

Re: how to hide sheets according to the kind of user

Go to Settings --> Document Properties --> Sheets --> Select the sheet properties and remove the condition or disable the option.

This may works as you expected. Can you short your qvw file and meanwhile, Just login from different user where we are not initiating in the condition and check how this looks like?

Life is so rich, and we need to respect to the life !!!

Re: how to hide sheets according to the kind of user

As always, Section access takes as UPPER Names only.

Life is so rich, and we need to respect to the life !!!