Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community;
Good Day
As I`m texting You, i have a problem which i describe as below:
I need to find out how to select red background color cell in Qlik view in VBscript.
I appreciate your help as soon as possible, thanks a million.
which cell are you referring to?
why using VBScript when a background colour expression might do as well?
Hi,
You can change the color in dimension Background color or expression background color.
I think no need to use VBScript for color back ground.
As mentioned above from others you can do so by picking up the specific color or even you can give condition in "Background Color" to either display it as red or in some other color
Hi Pooja,
he is asking about VB Script, not in expression.
May be this:
You can change color of selected field ...follow below instructions
Settings -> Document Properties -> General -> Color Scheme and choose [Custom].
Settings -> Document Properties -> Triggers
add to "OnOpen"
Action Type: External / Run Macro
sub [Color]
set up = ActiveDocument.GetApplication.GetUserPreferences
up.CustomSelBgColor(1).PrimaryCol.Col = RGB (255,0,0)
ActiveDocument.GetApplication.SetUserPreferences up
end sub
OR - (Another macro)
sub ChangeColorActive
'sets the value non active color of all sheets
for i=0 to ActiveDocument.NoOfSheets-1
set vSheet = ActiveDocument.GetSheet(i)
set vSheetProp = vSheet.GetProperties
vSheetProp.TabAttr.BgColor.PrimaryCol.Col = RGB(241,238,229)
vSheetProp.TabAttr.FgColor.PrimaryCol.Col = RGB(232,98,32)
vSheetProp.TabAttr.Mode = 2
vSheet.SetProperties vSheetProp
next
'Determine active sheet and sets the value active color
set vSheet = ActiveDocument.ActiveSheet
set vSheetProp = vSheet.GetProperties
vSheetProp.TabAttr.BgColor.PrimaryCol.Col = RGB(67,117,115)
vSheetProp.TabAttr.FgColor.PrimaryCol.Col = RGB(250,245,120)
vSheetProp.TabAttr.Mode = 2
vSheet.SetProperties vSheetProp
End sub
I want to filter a red cell in chart object with a specific column by clicking on one button.