topic Re: Help with dynamic Tab color in QlikView

Help with dynamic Tab color

mikecrengland — Fri, 12 Jul 2013 19:43:09 GMT

Hello All --

I've been changing the color of the active tab with something similar to

=if(GetActiveSheetId() = 'Document\SH24', ARGB(255,255,160,65), argb(255,225,225,225))

but it annoys me that I have to remember to call out each sheet ID. I tried to create a variable (vSheet) to use in the expression:

=chr(39)&GetActiveSheetId()&chr(39)

Then in the tab color:

=if(GetActiveSheetId() = vSheet, ARGB(255,255,160,65), ARGB(255,225,225,225))

But it doesn't work.

I added an input box to verify that vSheet brought back 'Document\SH24' (or whatever the active tab is) and it seems to work.

Now I'm stumped. Can anybody help me with what I've done wrong?

Thanks!

mike

Re: Help with dynamic Tab color

Anonymous — Fri, 12 Jul 2013 19:54:21 GMT

Try to remove these chr(39). Define the vSheet as

=GetActiveSheetId()

Re: Help with dynamic Tab color

mikecrengland — Fri, 12 Jul 2013 19:55:58 GMT

Thanks, Michael. Unfortunately, no luck.

Re: Help with dynamic Tab color

Anonymous — Fri, 12 Jul 2013 20:01:12 GMT

I see.

The logic works (it is visibale in the text boxes), but it is not the logic you want. You have to refer to the specific sheet in each sheet color properties 😞

Re: Help with dynamic Tab color

mikecrengland — Fri, 12 Jul 2013 20:02:14 GMT

I was afraid of that.. Oh well, it was worth a shot. Thanks!

Re: Help with dynamic Tab color

rustyfishbones — Fri, 12 Jul 2013 20:16:54 GMT

https://www.youtube.com/watch?v=aEAUHt6GzJA&feature=youtube_gdata_player

Check out the above link to a Youtube video that may help

Re: Help with dynamic Tab color

Anonymous — Fri, 12 Jul 2013 20:25:54 GMT

Hi Alan,

Your video is fine, but you still have to define the sheet id explicitly in each color expression, what Mike R attempted to avoid.

Re: Help with dynamic Tab color

mikecrengland — Fri, 12 Jul 2013 20:28:21 GMT

Thanks Alan. That's a clever method. But like Michael mentioned, I was hoping to avoid having different expressions on different tabs. Some would call it lazy, but I prefer 'efficient'...

Re: Help with dynamic Tab color

rustyfishbones — Fri, 12 Jul 2013 20:42:08 GMT

You are correct, I did not read the question correctly

Re: Help with dynamic Tab color

paulyeo11 — Sat, 13 Jul 2013 05:42:50 GMT

Hi Alan

Your approach is too complicated need many step. Recently I found one approach very much simple most important it serve the same purpose.

Re: Help with dynamic Tab color

rustyfishbones — Sat, 13 Jul 2013 08:49:32 GMT

Cool, please share your app showing this simple approach

Re: Help with dynamic Tab color

CELAMBARASAN — Sat, 13 Jul 2013 11:04:12 GMT

Hi Mike,

Qlikview doesnot has the function of getting this sheet id and only has active sheet id. You can only achieve this with different expression.

The expression you wrote will always returns true for all the tabs. Only solution I can give is use different expression for each and every tab.

Instead of remembering the sheet id , you can use On Activate sheet trigger to set variable as you desired and go with your format in your expressions.

Attached sample.

Regards,

Celambarasan

Re: Help with dynamic Tab color

paulyeo11 — Sun, 14 Jul 2013 12:06:32 GMT

Hi Cel

your approach even better then mine. because i don't need to remember sheet name , just number.

but when i try to create a new sheet4 ID = 05, and i insert the expression at custom color .

=if(vActiveSheet = 5, ARGB(255,255,160,65), ARGB(255,225,225,225))

it does not work , why ? what i miss out ?

Re: Help with dynamic Tab color

paulyeo11 — Sun, 14 Jul 2013 12:10:06 GMT

Hi Alan

http://community.qlik.com/message/366772#366772

Above is not from me is from Gysbert.

Re: Help with dynamic Tab color

rustyfishbones — Sun, 14 Jul 2013 13:17:44 GMT

Thanks

Re: Help with dynamic Tab color

rustyfishbones — Mon, 15 Jul 2013 21:25:23 GMT

Hi All,

here is a new video showing 8 different options to change Tab Colour.

http://youtu.be/g1vIwNx8DMQ

Although I still think none of them will answer the original question, but hey!!! I am sure it will help some people out