topic Re: Access hidden tab in macro in QlikView

Access hidden tab in macro

Fri, 11 Oct 2013 23:08:27 GMT

Hi guys,

is it possible to acces the content of hidden tab in macro pragmatically?

Saurabh

Re: Access hidden tab in macro

srchilukoori — Fri, 11 Oct 2013 23:23:07 GMT

yes, what are you trying to implement?

Re: Access hidden tab in macro

Fri, 11 Oct 2013 23:25:57 GMT

I have to change the content of my hidden script for each user who access it.

Can you please tell me how we can access the hidden script?

Re: Access hidden tab in macro

srchilukoori — Fri, 11 Oct 2013 23:29:07 GMT

Is it hidden tab or hidden script?

Re: Access hidden tab in macro

Fri, 11 Oct 2013 23:34:41 GMT

it is hidden script...the thing that we create by going to File->Create Hidden script.

Is hidden tab something else in QB?

I am very new to QV so please excuse me for my ignorance.

But what is difference between Hidden tab and Hidden script?

And can we change hidden script?

Re: Access hidden tab in macro

srchilukoori — Fri, 11 Oct 2013 23:39:16 GMT

Script can't be changed based on the user who logged in.

However, you can access the charts in the hidden tabs (sheets) with macros like export to excel etc.

Re: Access hidden tab in macro

Fri, 11 Oct 2013 23:42:52 GMT

I just saw that ActiveDocument.DocumentProperties().Script which gives us the whole script but the hidden script as string and we might change it save it back.

So i thought there might be a way to access the hidden script by providing the password.

Re: Access hidden tab in macro

Sat, 12 Oct 2013 00:50:03 GMT

Hi Ramya,

The only way to access the hidden script is by editing scritp providing the password. Probably you can not do this through a macro.

Re: Access hidden tab in macro

mattydolan — Thu, 03 Jan 2019 11:09:17 GMT

It's possible to modify and read hidden script using VBScript using the ActiveDocument.GetCovertScript and ActiveDocument.SetCovertScript functions.

Link: https://community.qlik.com/t5/QlikView-Scripting/Managing-Hidden-Script/td-p/1165353

There is some information in the APIGuide but it seems only from 2013 version onwards which I can't find a direct download link (it's available upon install of Qlikview with Manual/Help however I can't re-install Qlikview on my machine)

I've pasted some VBScript for those still interested (it took me a while to find this)

Sub ReadHiddenScript
stOldScript = ActiveDocument.GetCovertScript("pass")
msgbox(stOldScript)
End Sub

Sub WriteHiddenScript

stNewScript = "//New Script"

blSuccessful = ActiveDocument.SetCovertScript("pass",stNewScript)

msgbox blSuccessful
End Sub

I'm planning to use this to modify hiddenscript on the fly by reading the whole script and replacing certain sections and then writing it again.