topic How to change the tab color when it is activated. in QlikView

How to change the tab color when it is activated.

Thu, 25 Apr 2013 08:44:05 GMT

Hi All,

I have one question on:

How to change the tab color when it is activated.

Can you help me out?

Thanks.

Re: How to change the tab color when it is activated.

Thu, 25 Apr 2013 08:51:56 GMT

Hi vishwaranjan,

Thanks for your quick reply, what I meant is I want to let all activated sheet tab with red, for unActivated one with black.

How to do it?

Re: How to change the tab color when it is activated.

er_mohit — Thu, 25 Apr 2013 09:07:03 GMT

see the attached file

try this

in custom tab color of sheet pr0perties then write below code in calculated

if(GetActiveSheetId()='Document\SH01',red(),Black())

Re: How to change the tab color when it is activated.

kumarnatarajan — Thu, 25 Apr 2013 09:23:02 GMT

Hi,

Find the attached file for tab color change

Use below syntex for dynamic current sheet id

=num(right(GetActiveSheetId(),2))

Re: How to change the tab color when it is activated.

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

Hi,

here is a video that will demonstrate 8 different ways of achieving this

http://youtu.be/g1vIwNx8DMQ

hope you find it useful!

Re: How to change the tab color when it is activated.

paulyeo11 — Tue, 16 Jul 2013 00:07:26 GMT

you are very good programmer.

Re: How to change the tab color when it is activated.

rustyfishbones — Thu, 18 Jul 2013 10:58:51 GMT

here is another way that's not in the video

IF(MID(GetActiveSheetId(),10,4) ='SH01',GREEN())

MID will always start at 10 for GetActiveSheetId() if you want to return the Sheet number

Document/SH01, Therefore the above Expression will give SH01

Re: How to change the tab color when it is activated.

paulyeo11 — Thu, 18 Jul 2013 11:40:08 GMT

Hi Alan

Can you make a conclusion on which is the best approach in term of most simple ?

Re: How to change the tab color when it is activated.

rustyfishbones — Thu, 18 Jul 2013 11:46:45 GMT

I would say using the RIGHT function is most simple

IF(RIGHT(GetActiveSheetId(),4)='SH01',GREEN())

I only say that because it's a function used in lot's of different Applications and would be well know to most beginners

Regards

Alan

Re: How to change the tab color when it is activated.

Alexander_Thor — Thu, 18 Jul 2013 12:34:01 GMT

I might add that if a user creates a sheet it wont get the document prefix so the right() approach solves that kinda nicely. What bugs me though is that I haven't been able to figure out a totally dynamic expression that don't forces me to hard code the sheet id.

Re: How to change the tab color when it is activated.

timmarsh — Wed, 27 Nov 2019 03:20:00 GMT

This doesn't quite work, cannot get to unset on exit.

I set 2 colour variables:

let vColHighlight = 'rgb(193,217,255)'; let vColNoHighlight = 'rgb(132,189,220)';

For a sheet, I then use a trigger like this:

Set another variable vViewMode

Set an OnActivate Trigger: set variable vViewMode to be Dashboard

Then in General->Custom Colours, I set the colour

=if(vViewMode = 'Dashboard', $(vColHighlight), $(vColNoHighlight))

However, I can't get the OnLeave Trigger where I set vViewMode to be 0, '' for it to change to vColNoHighlight,

I think this might be a good option: https://community.qlik.com/t5/QlikView-App-Development/Setting-active-tab-color/td-p/277965