Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner - Specialist
Partner - Specialist

How to change TAB Color??

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Not applicable

Hi Ajit,

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

Regards,

Raj.

Vegar
MVP
MVP

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

whiteline
Master II
Master II

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

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
jsingh71
Partner - Specialist
Partner - Specialist
Author

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