topic Re: Tab colour highlighting on selection in QlikView

Tab colour highlighting on selection

Thu, 09 Jan 2014 11:26:21 GMT

Hi all

I'm trying to get the tabs to change background and text colour when selected. I want white background and black text when inactive and blue background and white text when clicked on.

I've tried putting this formula in the tab settings:

If (GetActiveSheetId()='Document\SH01',RGB(0,128,255), White())

But I can't seem to get it to do it the right way round. Can anyone help me with this?

TIA!

Regards

Alex

Re: Tab colour highlighting on selection

Thu, 09 Jan 2014 11:30:45 GMT

Hello,

I've figured this out now, thanks for your time.

Regards

Alex

Re: Tab colour highlighting on selection

ThornOfCrowns — Thu, 09 Jan 2014 11:43:51 GMT

Would you like to report how you did it for the benefit of others who may read this thread in the future?

Re: Tab colour highlighting on selection

dmohanty — Thu, 09 Jan 2014 11:59:00 GMT

Hi,

Try using like this:

For Tab Color, Go to Sheet Properties>>Tab Settings>>Tab Color>>Custom Colors>>Calculated, put the expression:

if(GetActiveSheetId()='Document\SH01',blue(),white())

For TAb Text color, Go to Sheet Properties>>Tab Settings>>Tab Text Color>>Custom Colors>>Calculated, put the expression:

if(GetActiveSheetId()='Document\SH01',white(),black())

If this helps, mark the Post as Correct, to help others!

Re: Tab colour highlighting on selection

Thu, 09 Jan 2014 11:59:30 GMT

Hi Alex,

Please find the attachment, May be it helps you.

Re: Tab colour highlighting on selection

Thu, 09 Jan 2014 12:01:46 GMT

Sure thing!

For the tab colour, go to Sheet Properties click Custom Colour/Tab Colour. First click Fixed and select the colour you want (mine was the following blue R=0, G=128, B=255). Then select Calculated and enter the same colour into the Expression Box. The formula is:

If(GetActiveSheetId()='Document\SH02',RGB(0,128,255),white())

Note: make sure that the sheet number (SH02) matches the Sheet ID or it won't appear to work.

For the text colour, click on Custom Colour/Tab Text Colour. First click Fixed and select Black on the Basic Colours. Then select Calculated and enter the following formula to get white:

If(GetActiveSheetId()='Document\SH02',white(),black())

This will then give you the blue tab with white text when you select that tab.

Regards

Alex

Re: Tab colour highlighting on selection

Thu, 09 Jan 2014 12:02:57 GMT

Thanks very much - I'm sure I'll use that somewhere on this app!

Regards

Alex