topic Active Tab Color in QlikView

Active Tab Color

Wed, 16 Sep 2009 14:43:07 GMT

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

Active Tab Color

biester — Wed, 16 Sep 2009 14:49:05 GMT

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

Active Tab Color

prieper — Wed, 16 Sep 2009 14:49:18 GMT

Hi,

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

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

HTH
Peter

Active Tab Color

Wed, 16 Sep 2009 17:42:33 GMT

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.

Active Tab Color

Wed, 16 Sep 2009 17:45:33 GMT

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.

Active Tab Color

Wed, 16 Sep 2009 17:47:19 GMT

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

Active Tab Color

johnw — Thu, 17 Sep 2009 04:00:01 GMT


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.

Active Tab Color

prieper — Thu, 17 Sep 2009 21:41:30 GMT

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