topic Remove tabs in QlikView

Remove tabs

Sun, 18 Sep 2011 13:11:02 GMT

Hello QV experts,

Is it possible to remove tabs from script editor using a macro?

I have multiple tabs (not sheets) in the script editor. I dont require all of them after first reload. I want to remove few of them but not manually. I would like to do this using a macro call subs or function call?? Please help me if this is possible to achive

Thanks & Regards

Padmasali

Remove tabs

Sun, 18 Sep 2011 13:44:05 GMT

ActiveDocument.RemoveSheet 1 should work.

Regards,

Kiran.

Remove tabs

Sun, 18 Sep 2011 13:45:31 GMT

ActiveDocument.RemoveSheetByID "SH01" is more appropiate.

Regards,

Kiran.

Remove tabs

Sun, 18 Sep 2011 17:45:17 GMT

Hi Padmasali,

If I am not wrong, you might beon of thse two kind of situation.

1. You have only one tab,you don't user to see it as a tab:

Go to Settings>>Document Properties(Ctrl+Alt+D)

On General Tab:

Select Hide Tab row

2. You have multiple tabs, but you do not want to see the tabs on the top:

Create Mutile Buttons for the tabs.Go to Properties of the Button.

Properties>> Action. Click the Add button

Choose Action type as "Lay Out" and Action as "Activate Sheet"

Now fill the Sheet Id for other tabs.

Hope it might help.

Remove tabs

Mon, 19 Sep 2011 02:37:26 GMT

Hi Panmasali

Remove tabs you just click on Tab then click Remove is OK

Bgds

ENN

Remove tabs

Mon, 19 Sep 2011 10:43:15 GMT

Hi Padmasali,

I misunderstood your requirement. There are two ways I usually do:

1. Add IF IsPartialReload flag and segment the script to full reload vs. updates.

2. You can run set a variable to 1/0 based on your parameter an segment your script. This way when you run a second reload only partial script is reload

Hope this helps.

Regards,

Kiran.