Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

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

Hi,

Hope this will help you.

Thanks & Regards

Not applicable

Thank you upendra

Not applicable

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
Contributor III
Contributor III

Thanks! This is helpful!

maxgro
MVP
MVP

an example in my attachment here

Re: How to hide sheet from users?

vijayit43
Creator
Creator

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this too.

Sheet level access

Regards

ASHFAQ