Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background color change on Sheet Activated

How to change background color on Activation of Sheet

2 Replies
rubenmarin

Hi, you can use a varible to do this, ie:

create a variable vBgColor, you can assign a valur like: RGB(255,255,255)

use this variable to assign the background color: $(vBgColor) or just =vBgColor

In sheet properties create a trigger for activate sheet with an action, Type: external, Action: establish variable, then assign to the varibale vBgColor the color you want to change, ie: RGB(180,180,255)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

I'm not sure what you mean with "Activation of sheet"? If a sheet isn't activated, it's either completely invisible, or hidden by another sheet so that only the sheet tab is visible. In the first case, changing the background color is rather useless. In the second case, you can only change the tab color (see Sheet properties->General->Tab settings->custom colors).

To change a tab color when a sheet is moved to the front, you can use a color expression like:

=If(SubField(GetActiveSheetId(),'\',2) = 'SH01', white(), black())

Don't forget to change the tab text color as well.

Peter