how to change button color according to sheet selection

[#1]

Hi all,

I have buttons which are used to navigate between my sheets.

How can I change the color of the button according to the sheet I'm in?

Thanks,

Boris

[Colin-Albert]

Try this http://community.qlik.com/message/323282#323282

[maleksafa · Accepted solution]

using the GetActiveSheetId() you can know what is your current sheet, use it to change the color of the button, go to button properties, background color, base color, calculated: and there you can put for example if (GetActiveSheetId() = 'Document\SH01', Red())

[Peter_Cammaert]

This is a nice one. It automatically assigns button colors based on the sheet ID. Adjust the INLINE table in the script and add a fourth color. Then on the third sheet, select rightmousemenu->Copy sheet.

TADA!