topic Re: Reference to "this sheet" in QlikView

Reference to "this sheet"

Anonymous — Wed, 19 Feb 2014 00:27:53 GMT

I'm looking for a way to reference the sheet whose properties I'm in.

I have a calculated tab color as follows:

=if(GetActiveSheetId()='Document\SH02',rgb(141,198,63),rgb(0,157,220))

However, I'm getting sick of manually switching the sheet ID ('Document\SH02') on every sheet to make the tab color work properly - I can't set it as the document default, use it in a theme, etc. because it has to be done manually as far as I can tell.

Is there a way to reference "this sheet" so I could do something like:

=if(GetActiveSheetId()=GetThisSheetID(),rgb(141,198,63),rgb(0,157,220))

???

Thanks!

Re: Reference to "this sheet"

MK_QSL — Wed, 19 Feb 2014 00:41:53 GMT

Unfortunately there is no such a function available.

You can use little shorter version as..

if(wildmatch(GetActiveSheetId(),'*SH02'), RGB(141,198,63),RGB(0,157,220))

Re: Reference to "this sheet"

Colin-Albert — Wed, 19 Feb 2014 00:52:32 GMT

Perhaps an OnActivateSheet trigger could set a variable to 1,2,3 as you change sheet, and then set the tab colour using the variable.

Re: Reference to "this sheet"

rwunderlich — Wed, 19 Feb 2014 01:38:31 GMT

=if(GetActiveSheetId()=GetThisSheetID(),rgb(141,198,63),rgb(0,157,220))

That expression would always be true, wouldn't it?

If you always want a sheet to have a particular color, can you set that sheet's tab color to a fixed color?

-Rob

Re: Reference to "this sheet"

Anonymous — Wed, 19 Feb 2014 07:00:55 GMT

The length isn't the problem - It's the needing to edit it individually on each sheet that drives me nuts.

Re: Reference to "this sheet"

Anonymous — Wed, 19 Feb 2014 07:08:42 GMT

Rob, I'm envisioning the "GetThisSheetID" not as an active sheet id, but the id of the sheet whose properties it's entered in. So if I entered that expression on SH01, GetThisSheetID would always return SH01 in that instance and GetActiveSheetID would always be the active sheet.

Yeah, wishful thinking. But, I'm a techie. When I do something that takes 10 seconds three times or more, I have to look for a way to automate it. xkcd: Automation

Re: Reference to "this sheet"

rwunderlich — Wed, 19 Feb 2014 15:09:59 GMT

I'm not sure if you were replying to my post. but my question was why use a conditional expression at all? I think I may be mis-understanding the problem.

-Rob

Re: Reference to "this sheet"

Anonymous — Wed, 19 Feb 2014 17:35:35 GMT

Hi Rob,

The client has specified different colors for the active sheet tab and inactive sheet tabs. Hence, the conditional. However, copying it to all tabs or including it in the theme includes the current sheet's ID - Meaning that when the sheet I'm in the properties for when I do that is active, ALL the tabs change color. So, I have to go back to every sheet, go into the properties, colors, calculated color, and change the sheet ID to that sheet's ID.

Unfortunately, I did accidentally include this in the theme, so now every time I reapply the theme after a change in the spec, I have to go through the process again! Unfortunately, the theme has been a bit of a moving target so these changes are driving me bananas.

Re: Reference to "this sheet"

swuehl — Wed, 19 Feb 2014 17:45:53 GMT

You may want to vote for

http://community.qlik.com/ideas/1938

Re: Reference to "this sheet"

rwunderlich — Wed, 19 Feb 2014 18:10:58 GMT

I understand now.

-Rob

Re: Reference to "this sheet"

Wed, 19 Feb 2014 18:50:27 GMT

Hi Kent,

I don't know if I understood correctly but I will comment you some ideas.

If you are using the copy sheet option to duplicate a sheet, this function keep the same ID for two sheets so I normally create new sheets and then copy the objects to the new sheet; with this way the objects and sheets will have differents ID.

For work with the colors of the tabs, you can define same variables with RGB color codes and then use this variables from the sheets properties. You also can use other variable with numbers, and define one number for each sheet, then in each sheet you question if(vVariable = 1, vRGB1, vRGB2) for example, and the code is more reutilizable.

Regards.