topic Properties of a Hidden Sheet in QlikView

Properties of a Hidden Sheet

michaelfreitas — Wed, 05 Oct 2011 20:02:23 GMT

How to get the properties of a hidden sheet? Using VBS.

Urgently needed, help please.

Thanks

Re: Properties of a Hidden Sheet

Wed, 05 Oct 2011 20:17:12 GMT

You should be able to reference the hidden sheet using the sheet's sheet ID.

Properties of a Hidden Sheet

michaelfreitas — Wed, 05 Oct 2011 20:24:47 GMT

Thanks for responding!
I've tried several ways and can not, if the tab is hidden with conditional.

set Result = ActiveDocument.GetSheetById("SH04").GetProperties

set Result = ActiveDocument.Sheets(SH04).GetProperties

Thanks

Re: Properties of a Hidden Sheet

Sokkorn — Thu, 06 Oct 2011 01:09:03 GMT

Hi,

Try to check QV API in your local installation C:\Program Files (x86)\QlikView\Documentation\APIguide.qvw

Let me know if this one help you.

Regards,

Sokkorn

Re: Properties of a Hidden Sheet

Thu, 06 Oct 2011 06:22:32 GMT

Hi,

I dont think we any such option to access hidden sheet.

But i think you know that to access that hidden sheet manually, you should go to Settings -> Document Properties -> Sheets tab.

Cheers.

Properties of a Hidden Sheet

michaelfreitas — Thu, 06 Oct 2011 18:30:51 GMT

Thank you, Cheers and Sokkorn.
I do use the API GUIDE long ago, and has developed many scripts from it.
We also know the tool options.
But one of the few things I could not do today is get the settings from a hidden sheet via macro.
If any of you, friends, know I'll be very grateful, because I've tried everything.

Re: Properties of a Hidden Sheet

Fri, 07 Oct 2011 13:38:31 GMT

Sorry it has taken me so long to respond again, I was out of my office yesterday. I did alittle bit of research for you, and everything that I have seen shows that you are not able to reference a hidden sheet to get the properties. I am wondering though if it is possible to unhide the sheet temporarily get the properties and then rehide it. If you want to try this, I will as well, and Ill let you know.

Regards,
Jeff

Re: Properties of a Hidden Sheet

michaelfreitas — Fri, 07 Oct 2011 14:01:47 GMT

Thank you Jeff for concern, help me.

I discovered a light at the end of the tunnel.

Shortcut keys ctrl + shift + s
http://community.qlik.com/message/31300#31300

They display all the sheets and pressing them again appear.

Helps, as I activate the shortcut, run the macro again and off using the shortcut.

Regardless of the sheets possess conditional, the shortcut displays them.

As I understand conditionals are only disabled and enabled again.

I would also like to know the original question. But this time, the solution of the shortcut helps.

Original question: How to get the properties of a hidden sheet? Using VBS.
New question: Simulate Ctrl + shift + s, using VBS.

Thanks Jeff and other friends

Re: Properties of a Hidden Sheet

Mon, 10 Oct 2011 14:55:02 GMT

Hey Michael,

I had just thought of something. If you have the sheets hidden based off a variable, say the variable = 1. Then have it so the sheet is not hidden if the variable is equal to 1. Now change the value of the variable to 2 and it will be hidden. In your macro you could unhide the sheet with the variable, get the properties and then rehide it. I did find a method in VBS that contains sending the automation of the key strokes. .SendKeys "^+s" i believe that is what it would look like. It is a function of an object. Just for reference the ^ = Ctrl, + = Shift, and then s. Hope this helps!

Regards,

Jeff

Re: Properties of a Hidden Sheet

michaelfreitas — Mon, 10 Oct 2011 18:24:45 GMT

Very interesting SendKeys function, but found nothing in APIGuide or on the web. Nothing works.
QlikView is found where the option simulated this shortcut:
Document Settings .. Properties .. .. Security Option Show all folders and objects.

And through this macro should change the value. But do not get run.

temp = ActiveDocument.GetProperties.UserPermissions.ShowAllSheetsAndObjects
if temp then msgbox ("Show on condition ADMIN override")
temp = ActiveDocument.GetProperties
temp.UserPermissions.ShowAllSheetsAndObjects = false
ActiveDocument.SetProperties temp

If you can run the macro, and/or SenKeys, I'll be grateful.

Re: Properties of a Hidden Sheet

Mon, 10 Oct 2011 18:57:35 GMT

http://msdn.microsoft.com/en-us/library/8c6yea83(v=vs.85).aspx

The link goes to a site that describes the VBScript and JScript for the SendKeys Method.

Re: Properties of a Hidden Sheet

michaelfreitas — Mon, 10 Oct 2011 19:44:22 GMT

I appreciate the help, but I could not in any way.

If anyone can make it work, please notify.

Thanks to all

Re: Properties of a Hidden Sheet

Anonymous — Fri, 09 Feb 2018 11:50:03 GMT

Hi Michael,

Not sure if you ever found a solution to this.

I have tried options to set document properties and also SendKeys but none of them work.

Would appreciate if you could share any new leads you had on this matter.

Regards,

Biju