topic Re: Want to hide sheets from being accessed by user in QlikView

Want to hide sheets from being accessed by user

renjithpl — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Want to hide sheets from being accessed by user

Fri, 27 May 2011 07:33:26 GMT

Hi,

Hope this will help you.

Thanks & Regards

Want to hide sheets from being accessed by user

Wed, 01 Jun 2011 18:11:56 GMT

Thank you upendra

Re: Want to hide sheets from being accessed by user

Wed, 01 Jun 2011 19:41:51 GMT

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.

Re: Want to hide sheets from being accessed by user

chadwatson — Fri, 03 Oct 2014 17:57:39 GMT

Thanks! This is helpful!

Re: Want to hide sheets from being accessed by user

maxgro — Fri, 03 Oct 2014 18:49:23 GMT

an example in my attachment here

Re: How to hide sheet from users?

Re: Want to hide sheets from being accessed by user

vijayit43 — Sat, 04 Oct 2014 06:56:00 GMT

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

ashfaq_haseeb — Sun, 05 Oct 2014 12:46:08 GMT

Hi,

Check this too.

Sheet level access

Regards

ASHFAQ