Background Color cell

[aghahraman]

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.

[MarcoWedel]

which cell are you referring to?

why using VBScript when a background colour expression might do as well?

[pooja_prabhu_n]

Hi,

You can change the color in dimension Background color or expression background color.

[qlikviewwizard]

I think no need to use VBScript for color back ground.

[nishanthi_8]

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

[pintucs20]

Hi Pooja,

he is asking about VB Script, not in expression.

[balabhaskarqlik]

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    

[aghahraman]

I want to filter a red cell in chart object with a specific column by clicking on one button.