topic Re: Background Color cell in QlikView

Background Color cell

aghahraman — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Background Color cell

MarcoWedel — Thu, 26 Jul 2018 19:28:35 GMT

which cell are you referring to?

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

Re: Background Color cell

pooja_prabhu_n — Fri, 27 Jul 2018 05:46:53 GMT

Hi,

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

Re: Background Color cell

qlikviewwizard — Fri, 27 Jul 2018 05:54:45 GMT

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

Re: Background Color cell

nishanthi_8 — Fri, 27 Jul 2018 07:03:16 GMT

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

Re: Background Color cell

pintucs20 — Sat, 28 Jul 2018 07:08:53 GMT

Hi Pooja,

he is asking about VB Script, not in expression.

Re: Background Color cell

BalaBhaskar_Qlik — Sat, 28 Jul 2018 07:45:27 GMT

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

'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

Re: Background Color cell

aghahraman — Wed, 01 Aug 2018 10:05:51 GMT

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