Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

renjithpl
Valued Contributor

Want to hide sheets from being accessed by user

Hi,

I dont want one of my user to access certain sheets in my qvw file. I used section access for different user, but i dont know how to hide sheets for different user.

When a user logs in using userid and pwd, some sheets should be hidden.

Regards

Ranjit

7 Replies
Not applicable

Re: Want to hide sheets from being accessed by user

Hi,

Hope this will help you.

Thanks & Regards

Not applicable

Want to hide sheets from being accessed by user

Thank you upendra

Not applicable

Re: Want to hide sheets from being accessed by user

I am unable to unrar your file.

You could create a field in your users table, something like ShowTabs. Everyone would have a 1 there, except the user in question.

Since your Security Table will not be available after Section Access is used, I would reload the contents of your Security table into another table and Qualify it.

Something like:

SecurityTable:

Load ...

Qualify *;

AccessTable:

Load * Resident SecurityTable;

Unqualify *;


Then on your charts Conditional Show, use: AccessTable.ShowTabs = 1.

chadwatson
New Contributor III

Re: Want to hide sheets from being accessed by user

Thanks! This is helpful!

MVP
MVP

Re: Want to hide sheets from being accessed by user

an example in my attachment here

Re: How to hide sheet from users?

vijayit43
New Contributor III

Re: Want to hide sheets from being accessed by user

Use this code in script where 1 show page and 0 hide page

REPLACE LOAD * INLINE [

    USER,        PAGE01,    PAGE02,    PAGE03,    PAGE04

    XXXXX,        1,        1,        1,        1

    USERID,        1,        1,        1,        0

Re: Want to hide sheets from being accessed by user

Hi,

Check this too.

Sheet level access

Regards

ASHFAQ

Community Browser