topic Re: How to change TAB Color?? in QlikView

How to change TAB Color??

jsingh71 — Fri, 02 Nov 2012 08:02:43 GMT

I have 7 Tabs in my qvw file now I want when I select any particular tab it color will become yellow.

Where is this setting?

Re: How to change TAB Color??

Fri, 02 Nov 2012 08:12:50 GMT

Hi Ajit,

Sorry I Didn't Get You Can You Please Send Me your Test App.

Regards,

Raj.

Re: How to change TAB Color??

Vegar — Fri, 02 Nov 2012 08:21:09 GMT

Hi,

Look under "tab settings" in the sheet properties for every sheet.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

Re: How to change TAB Color??

whiteline — Fri, 02 Nov 2012 08:27:50 GMT

Hi.

There is no such setting. You can set color statically.

But you can use Actions and a Macro to change the tab color dynamically.

There is an example in API Guide.qvw:

set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.TabAttr.BgColor.PrimaryCol.Col = RGB(255,0,0)
sp.TabAttr.FgColor.PrimaryCol.Col = RGB(0,255,0)
sp.TabAttr.Mode = 2 ' custom colors
mysheet.SetProperties sp

Re: How to change TAB Color??

Gysbert_Wassenaar — Fri, 02 Nov 2012 08:33:57 GMT

You can change the color of the tab on the properties screen of the sheet. Select Custom Colors under Tab Settings. Click on Tab Color, select the Calculated option under Base color and use as expression:

=if(GetActiveSheetId()='Document\SH02',yellow(),white())

Replace SH02 with the ID of the sheet you're changing the color setting. If you want you can use the same expression for the background color of the sheet so the entire sheet turns yellow if you select it.

Re: How to change TAB Color??

jsingh71 — Fri, 02 Nov 2012 09:16:58 GMT

Thank You Very Much Gysbert.....you rocked again...