topic Change colours in Tabrow in QlikView

Change colours in Tabrow

Anonymous — Tue, 29 May 2012 19:46:50 GMT

Hi,

How did they add variables vTab1_On, vTab2_On, vTab3_On, vTab4_On, vTab0_On to change a colours for Tabrow?

Please find attached file.

Thanks,

Change colours in Tabrow

mikecrengland — Tue, 29 May 2012 20:02:38 GMT

On the General tab of Sheet Properties. (bottom right)

Change colours in Tabrow

Anonymous — Tue, 29 May 2012 20:05:13 GMT

Thanks,

But there is a condition.

Regards,

Change colours in Tabrow

regowins — Tue, 29 May 2012 21:03:23 GMT

The vTab variables were added in the variable overview under settings menu.

Change colours in Tabrow

stevedark — Tue, 29 May 2012 21:15:35 GMT

As I think you have spotted already, the Calculated Colour code is important, and then the variables to say which tab is active are set by triggers. These are set on the Triggers tab of the Sheet Properties. On entering a tab the appropriate vTab variable is set to 1, on leaving it is set to 0.

The vTab variable is then used in the Conditional Colour expression.

If I were going for the same effect I would probably go for:

=if(GetActiveSheetId() = 'Document\SH04', rgb(255,79,79), rgb(255,255,255))

To avoid the use of triggers, but the way it has been done in the document you attached works fine too.

Hope that helps.

- Steve

Change colours in Tabrow

Anonymous — Wed, 30 May 2012 13:35:31 GMT

Hi Steve,

I added variables vTab1_on=1, other variables =0.

I added conditions for each tabrow, but my variables didn't change dynamically.

Maybe you know how set dynamically variables.

Thanks,

Change colours in Tabrow

stevedark — Thu, 31 May 2012 07:03:18 GMT

Just right click on a blank area of the sheet and right click and select Properties. Select the Triggers tab and create the required triggers. See the fast food example for details.

Or, use the example I posted above that doesn't require variables and triggers....

Change colours in Tabrow

Anonymous — Thu, 31 May 2012 13:26:32 GMT

I know this.

I don't know how to add variables which changed from 1 to 0, if selected a tabrow.

I saw in the example conditions and variables vTab_on changed from 0 to 1 indepent of current tabrow.

How to make changed variables?

Thanks,

Change colours in Tabrow

regowins — Thu, 31 May 2012 18:26:46 GMT

For example, if I do sheet 6 in the attached document.

1. Set variables vTab6_on = 0 in the variable overview

2. Sheet properties -> Triggers Tab

a. On Active sheet set an action for external trigger for a Variable. Set vTab6_on = 1

b. On Leave sheet set an action for external trigger for a Variable . Select vTab6_on = 0

3. General sheet properties -> Tab color -> calculated base color = If($(vTab6_On)=1, rgb(255,79,79), rgb(255,255,255))

Change colours in Tabrow

Anonymous — Thu, 31 May 2012 20:43:15 GMT

thanks!!!!!!!!!!!!!!!!!!!!!!!

Re: Change colours in Tabrow

rustyfishbones — Mon, 15 Jul 2013 21:16:38 GMT

Here is a video that shows 8 different ways to change the tab colours on selection

http://youtu.be/g1vIwNx8DMQ

hope it helps