topic Easiest Way to Hide Sheets in QlikView

Easiest Way to Hide Sheets

Tue, 02 Mar 2010 13:20:00 GMT

I would like to keep a separate sheet for me to work on with new draft reports & charts that no other user can see/access

What is the easiest way to do this?

Thanks

SV:Easiest Way to Hide Sheets

Tue, 02 Mar 2010 14:10:13 GMT

Show condition: qvuser()='You'

Easiest Way to Hide Sheets

Anonymous — Tue, 02 Mar 2010 14:24:52 GMT

If you use NTFS security instead of QV security then you can put

=OSUser()='yourdomainname\your_username'

in Sheet Properties -> General -> Show Sheet -> Conditional

I have files, where only several users can access to specific sheets. I also use both QV and NTFS security. In this case my sheet showing condition looks like:

=Match(QVUser(),'USER1','USER2') OR MixMatch(OSUser(),'domain\user1','domain\user2')

Rgs,
AT

Easiest Way to Hide Sheets

Tue, 02 Mar 2010 14:48:58 GMT

Note that if you use the above methods, you will also have to do the same on any reports that you create as well as in the sheet properties.

The other way is to simply use "vShow = 1" and create a variable called vShow. Manually changing this value will show/hide the sheet. Sure it's not as autonomous but still works.

The easiest way is to take a copy of the qve file and store it where only you can see. This also lowers the risk of breaking an application, if your work includes modification of the load script.

For a full answer you need to tell us exactly what you shall be hiding from other people.

Easiest Way to Hide Sheets

Tue, 02 Mar 2010 15:09:13 GMT

Apologies...do I create the 'vshow' variable in 'Variable Overview'? Assume I define it as '1' and then in the conditional bit I just add 'vshow'= 1'

New to a lot of this...would this variable therefore be unique to my instance of the QVD

Easiest Way to Hide Sheets

Mon, 05 Apr 2010 08:56:04 GMT

Good Morning Artjoms,

Sorry for disturbance through this mail.

Actually in my case also i have used =Match(QVUser(),'USER1','USER2') but my client asked that he will be create one table where all user's Domain,ID and Right will be available.Now i have to access that table and have to match OSUSER with the user having ADMIN rights for provding access to some sheets in the application.

So my issue can be summarized as follows -----

Hide some sheets in the Application available on the Server.

-----------------------------------------------------------------------

My Client asked me to hide some sheets of QV application available on Server (Accesspoint) based on the USER having ADMIN rights.

I have used Conditional SHOW sheet check-box with following logic --------

I have created 2 vairables named as "Admin" and "Var"

means for these sheets I have given SHOW SHEET condition as =(Admin)>0

Where "Admin" is a variable with definition

--------- =(fieldindex('ca_user',Var))

And "Var" is a variable with definition ----------- =subfield(osuser(),'\',2)

As you know, OSUSER() shows DOMAIN\USER-ID.

"ca_user" is a field(column) showing USER-ID with administration rights from a table created by Client.

It works fine on local machine but it doesn't work on Server like Accesspoint.

Insted of FIELDINDEX,i have used EXISTS but this function also works only on local machine not on the Server.

Could you please tell me how to hide sheets in the application available on the Server.

Thanks and Regards

Ajay

Easiest Way to Hide Sheets

rwunderlich — Tue, 06 Apr 2010 02:59:56 GMT

A convienent way to hide the "developer sheet" is to set the Conditional Show property of the sheet (General tab) to "0". This will hide the sheet. When you want to see the sheet press Ctl-Shift-s.

This is not a good way to hide secure data, but it works for the cosmetic stuff.

-Rob

Easiest Way to Hide Sheets

Thu, 25 Aug 2011 14:30:08 GMT

Hi Rob

I tried this and found that when document is published via AccessPoint (we use IE plugin) you cannot unhide the sheet again.

Working a treat when in the in development.

Is this a limitation?

Thanks

Soreen

Easiest Way to Hide Sheets

richnorris — Thu, 25 Aug 2011 14:49:17 GMT

Wow, Rob, never knew you could do that! Wish I had, could've saved me tons of time, heh! I'm sure that will prove very useful in the future! Top tip! For those who don't know: Ctrl + shift + s will overrule any conditional display of sheets or sheet objects so that everything becomes visible, and then toggles it back on again. This is especially useful for me, as I have a lot of hidden objects based on a users visibility restrictions, so working out all the permutations that can show a certain object is sometimes hard, being able to see everything no matter what is a Godsend!

Easiest Way to Hide Sheets

pho3nix90 — Mon, 05 Sep 2011 13:46:01 GMT

Another way,

Only display the sheet to your username/osuser, and hide for others.

right clikc on sheet -> properties -> click conditional under show sheet, the add the following expression:

=subfield(OSUser(),'\',2) = 'YOUR OSUSERNAME'

Easiest Way to Hide Sheets

pho3nix90 — Mon, 05 Sep 2011 13:48:30 GMT

to find out what your osuser is, add the following to a text object

=subfield(OSUser(),'\',2)

Re: Easiest Way to Hide Sheets

Mon, 05 Sep 2011 14:02:49 GMT

Ich werde ab 05.09.2011 nicht im Büro sein. Ich kehre zurück am

23.09.2011.

Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.

Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Verwertung des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt.

Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank!

Re: Easiest Way to Hide Sheets

Mon, 05 Sep 2011 14:02:50 GMT

Ich werde ab 05.09.2011 nicht im Büro sein. Ich kehre zurück am

23.09.2011.

Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.

Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank!

Easiest Way to Hide Sheets

swarup_malli — Thu, 03 Nov 2011 16:53:00 GMT

Very Helpful ..Thank u

Re: Easiest Way to Hide Sheets

jtanajewski — Tue, 20 Aug 2013 19:46:19 GMT

Great tip. Will use in future.

Re: Easiest Way to Hide Sheets

jtanajewski — Tue, 20 Aug 2013 19:49:18 GMT

Nice tip, too easy. Been looking for this. Don't want to delete tab, as I'll need to add back at later date.

Re: Easiest Way to Hide Sheets

felipe87 — Mon, 20 Jan 2020 19:51:25 GMT

I was trying to do this in QlikSense and was thinking I was so stupid because i couldn't make to work..

I just realize that this solution is for Qlikview(tried and was able to do it)..

But what about QlikSense Enterprise? Is there an Easy way to do it? I don't want to go through the QMC (even do they gave a lot of permission, I am afraid to do something wrong and end up messing the server (nobodies from TI really Knows how to configure the server ..had to figure out bi myself how to change app owner and other stuff)..

Thanks for your help!

Re: Easiest Way to Hide Sheets

paulyeo11 — Thu, 30 Apr 2020 07:41:02 GMT

Hello All

=Match(QVUser(),'USER1','USER2') OR MixMatch(OSUser(),'domain\user1','domain\user2')

I like to know, it is possible to use Apply Mapping? So that can enter domain/user data at excel file.

Paul

Re: Easiest Way to Hide Sheets

paulyeo11 — Thu, 30 Apr 2020 08:00:22 GMT

Hi All

Below are the sharing from Rob :-

A convienent way to hide the "developer sheet" is to set the Conditional Show property of the sheet (General tab) to "0". This will hide the sheet. When you want to see the sheet press Ctl-Shift-s.

This is not a good way to hide secure data, but it works for the cosmetic stuff.

I am using Ver 9. It can not work. It is work only above Ver 9

Paul