topic Re: how to change button color according to sheet selection in QlikView

how to change button color according to sheet selection

Mon, 12 Jan 2015 08:45:30 GMT

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

Re: how to change button color according to sheet selection

Colin-Albert — Mon, 12 Jan 2015 08:49:12 GMT

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

Re: how to change button color according to sheet selection

maleksafa — Mon, 12 Jan 2015 08:49:36 GMT

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

Re: how to change button color according to sheet selection

Peter_Cammaert — Mon, 12 Jan 2015 09:07:38 GMT

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!