topic Re: Setting active tab color in QlikView

Setting active tab color

Thu, 09 Jun 2011 17:54:35 GMT

I am trying to set the active tab color. In the attached document I tried to follow instructions below and seem to not be able to get it work. Any suggestions on how to set the variable values it discusses below.

First create a variable say vThisTab and set its value to 0.

Second go to Sheet Properties, Triggers, OnActivateSheet, Add Action, External, Set Variable, vThisTab, 1

Third, OnLeaveSheet, Set Variable, vThisTab, 0

Fourth, Sheet Properties, General, Tab Settings, Custom Colors, click on the Tab Color, Base Color, select Calculated and set the following conditional

If($(vThisTab) = 1, RGB(255, 0, 0), RGB(0, 255, 0))

Re: Setting active tab color

Thu, 09 Jun 2011 22:52:43 GMT

I think it will be hard tii get that method to work, since leaving a tab does not leave any trace.

I solved it by using a macro:

Set activeSheet = ActiveDocument.ActiveSheet

Sub SetTabColor

'Set old sheet color back
If (not isnull(activeSheet)) Then
    Set sp=activeSheet.GetProperties
    sp.TabAttr.Mode = 1   ' Sheet colors
    activeSheet.SetProperties sp
end if

'Now, save the new sheet
Set activeSheet = ActiveDocument.ActiveSheet

'And set the new tab color
Set sp=activeSheet.GetProperties
sp.TabAttr.BgColor.PrimaryCol.Col = RGB(255,0,0)
sp.TabAttr.Mode = 2 ' custom colors
activeSheet.SetProperties sp

End Sub

And then every tab need to call this makro in the OnActivateSheet trigger.

Re: Setting active tab color

erichshiino — Thu, 09 Jun 2011 23:32:31 GMT

Hi,

I created an app with that logic.

Please, check my attachment.

On each tab, check on the general properties -> tab colors

also, check the triggers on all of them .

Hope this helps,

Erich

Re: Setting active tab color

Thu, 02 May 2013 19:47:46 GMT

Great idea, Erich!

Re: Setting active tab color

rustyfishbones — Thu, 02 May 2013 20:03:51 GMT

I created a video on YouTube to show how to do the same

I hope it helps

http://youtu.be/aEAUHt6GzJA

Please share it if it works for you

Re: Setting active tab color

Mon, 15 Dec 2014 17:53:38 GMT

This works, and does exactly what I wanted it to do. Thanks, erich.shiino!

Re: Setting active tab color

michaelfentondata — Tue, 04 Aug 2015 00:33:52 GMT

I think it is better to use GetActiveSheetId() instead of variables. No need for sheet actions then.

Re: Setting active tab color

omerfaruk — Wed, 19 Dec 2018 11:28:48 GMT

Could you get this work on web view or access point?