Active Tab Color

[#1]

Hello,

afaik the difference between the active tab/sheet and an inactive tab is just the font.
E.g. the active tab has a bold font, whereas the tabs in the background have a plain font.

I'd like to show the active tab more outstanding by giving it a different color.
Example:
Tabrow: Blue-ish
Tabs: Blue
Active Tab: Orange

I did not find the option to set the 'active tab' color.
Can you cure my blindness ... or is this feature just not available?
(I am using V9)

Thank you,
Thilo

[biester]

I ain't found it either. You could perhaps simulate this with a OnActivate/OnLeaveSheet - Trigger, but I doubt whether it's worth the work ... I'd issue a feature request.

Rgds,
Joachim

[prieper · Accepted solution]

Hi,

there is already a post available, which should answer your question:

http://community.qlik.com/forums/p/20192/77253.aspx#77253

HTH
Peter

[#4]

I just put this solution together before seeing Peter's response:

1. Create a variable called ActiveSheet (or anything really)

2. Create a macro that checks the active sheet and sets the variable accordingly.

3. Make sure each sheet calls this macro upon activation.

4. Create custom "calculated colours" for the tab and (if you want to) the whole sheet.

I attached a simple example.

[#5]

Although my solution works perfectly well, I have just read the post suggested by Peter, I have to say that is a much better approach because once you have set it up it doesn't require maintenance. My solution would require changes to the macro each time you add a sheet.

[#6]

Hello all,

thanks for the help!

So I learned 3 things:
a) I have to use macros to achieve the goal.
b) I am not blind.
c) Always use Search before posting a question 😉

Thank you!
Thilo

[johnw]

Peter Rieper wrote:there is already a post available, which should answer your question:
http://community.qlik.com/forums/p/20192/77253.aspx#77253

Peter, I'm not actually sure what you're suggesting. The demo QVW that I put together for this a long time ago follows Nigel's approach. Are you suggesting that we follow the "hide tabrow" and custom button approach in the linked thread? Are you suggesting that we use lukeclock's macros? Those macros avoid the color expression, but are more complicated, which makes me nervous. Since you must still do work every time you add a tab, I'm not sure that editing the color expression as well is a big deal. So unless someone convinces me otherwise, I'd probably suggest Nigel's approach, even though Nigel is suggesting otherwise.

[prieper]

Hi John,

am not a fan of eyecatching additions, at least lukeclock's macro showed a way, which looks promising (although was refined recently). Nigel's solution looks pretty simple (and usually simple solution = good solution), you only need to adjust for each tab added.

Peter