topic Re: How to create a dynamic color tab ? in QlikView

How to create a dynamic color tab ?

Wed, 21 Nov 2012 17:59:43 GMT

Hi everybody,

I want to create a dynamic color tab.

I would have to have a tab in my help tab (Red on White) and the second tab is classic (grey/black).

Then when I click on the second tab my color of tab is (Red on white).

how can do it with variables or macro ?

Thanks,

Re: How to create a dynamic color tab ?

Anonymous — Wed, 21 Nov 2012 18:05:35 GMT

you can try it with change----- default color in active and inactive tab under option --"caption"

Re: How to create a dynamic color tab ?

MayilVahanan — Wed, 21 Nov 2012 18:08:21 GMT

PFA

Re: How to create a dynamic color tab ?

Anonymous — Wed, 21 Nov 2012 18:09:02 GMT

No macro needed, use conditional tab color (sheet properties), here is an example:

if(wildmatch(GetActiveSheetId(),'*SH01'), blue(), red())

Regards,

Michael

Re: How to create a dynamic color tab ?

Wed, 21 Nov 2012 20:29:32 GMT

Thanks a lot.

It's very great!!

Re: How to create a dynamic color tab ?

Fri, 08 Mar 2013 14:54:02 GMT

Declare a New Variable in Variable overview as 'ActiveSheet'

SUB SET_ActiveSheet

Write A Macro

SUB SET_ActiveSheet

if ActiveDocument.Sheets(1).IsActive then
ActiveDocument.Variables("ActiveSheet").SetContent "Sheet2", true
else if ActiveDocument.Sheets(2).IsActive then
ActiveDocument.Variables("ActiveSheet").SetContent "Sheet3", true

------

END IF

Call this Macro SUB SET_ActiveSheet In Each Sheets

Set Each sheet
Tab colour as calulated and set =IF ( ActiveSheet = 'Sheet1' , RGB(33,84,115)) then
=IF ( ActiveSheet = 'Sheet2' , RGB(33,84,115))...etc for each sheet

So According to selection Active Tab colour wil get chnaged.

Re: How to create a dynamic color tab ?

rustyfishbones — Mon, 15 Jul 2013 21:09:49 GMT

Hi Judikael,

Here is a video that shows 8 different ways in which this can be done

http://youtu.be/g1vIwNx8DMQ

It includes Michael's answer too!! thanks Michael