topic Selected tab in different color in QlikView

Selected tab in different color

Mon, 22 Nov 2010 20:05:01 GMT

Hi ,

I wanted to change the selected tab in the application to different color which makes it easy to differentiate between selected and not selected tab. Is it possible in Qlikview?

Selected tab in different color

Miguel_Angel_Baeyens — Mon, 22 Nov 2010 20:24:06 GMT

Hello,

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))

You're done.

Change the colors and set one value in each tab and that's all.

Hope that helps

Selected tab in different color

johnw — Mon, 22 Nov 2010 20:39:13 GMT

Whatever sheet you're entering is going to assign a value to vThisTab, so setting it to 0 as you leave shouldn't be necessary?

Selected tab in different color

Mon, 22 Nov 2010 21:28:38 GMT

If i try this all the tabs remain as the variable vThistab =1. In this case the tabs stay red irrespective of if selected or not.

Selected tab in different color

johnw — Mon, 22 Nov 2010 21:59:23 GMT

Seems to be working for me. See attached. My example is slightly different since I adapted it from an earlier macro example (now using actions), so perhaps one of the differences is significant.

my variable is activeSheet
I'm setting it to text values, different for each sheet
The sheets have color expressions like this: if(activeSheet='Main',lightgreen(),lightblue())

Ah, maybe what you're missing is that you need a different value for the variable for each sheet? If you use 1 for all of them, yeah, they'd all change to the highlight color and stay that way.

Selected tab in different color

Mon, 22 Nov 2010 22:14:53 GMT

Thanks a Lot John.I got it. It is working fine now.

Re: Selected tab in different color

Fri, 07 Jun 2013 16:52:03 GMT

Hi John,

I was reading this and it's exactly what I'm trying to do. I just don't know how to write the variable as text values. Would you mind giving me a suggestion?

Thanks!

Re: Selected tab in different color

Fri, 07 Jun 2013 19:35:15 GMT

Lavs - right-click on the tab header > Sheet Properties > Triggers. This is where John is using a Set Variable action to change the variable. The formula to change the colors is in Sheet Properties > General > Tab Settings > Custom Colors > formula. Hope that helps!

Re: Selected tab in different color

rustyfishbones — Fri, 07 Jun 2013 23:02:23 GMT

Try this video I done on YouTube

http://www.youtube.com/watch?v=aEAUHt6GzJA

Re: Selected tab in different color

Sat, 08 Jun 2013 20:26:15 GMT

perfect - thanks so much! it's now working like a charm!