Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Hi Ajit,
Sorry I Didn't Get You Can You Please Send Me your Test App.
Regards,
Raj.
Hi,
Look under "tab settings" in the sheet properties for every sheet.
Best regards
QlikView consultant at egbs consulting ab
Blog (in Swedish): bi-effekten.se
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
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.
Thank You Very Much Gysbert.....you rocked again...