Changing background color of unassociated data in a list box

[#1]

Hi,

How can we change the background color for the grey out values in a list box?

For ex-

Region

A

B

C

and if user selects A then B and C grey out, so i want any other color other than grey.

Please help.

Thanks in advance.

[#2]

Hi,

This is the default properties of Qlikview.

Selected field will appear as green
- This means that, this is the item of which you want to know more.
The result of the search is displayed instantaneously in all the
other sheet objects.

Thecells of associated field values are white
- Selected and associated values are referred to as possible values.

Unrelated data will
appear as gray - A
cell whose contents are not associated (whose value does
not occur in combination with that of the selected item) is called
excluded. The cells of excluded values are gray.

[#3]

Hi,

Try to do this with colour option in the expression(you can see in the picture below). In definition tab you can write IF statement with GetCurrentSelections function.Something like that IF( GetCurrentSelections = A, RGB = .... and etc).  )

Next you can use Format Painter Tool to save time (I hope to work in this situation ) for the other charts.

Regards,

Venelin

[#4]

Hi Aakansha,

perhaps this one:

Got to Settings -> Document properties -> general -> color scheme and choose [custom] in it.

Then you go to Document properties -> Triggers

add to "onOpen":

action: external -> Run macro

-> Name the macro and use the following code:

sub [Enter the macro name]

set up = acticedocument.getapplication.getuserpreferencesup.customselbgcolor(1).PrimaryCol.Col = RGB (X,Y,Z) //<- your preferred color --//

SecondaryCol.Col = RGB (A,B,C) //<- second color //

ActiveDocument.GetApplication.SetUserpreferences up

end sub

I think this is the only way to change the QV default color scheme but i am not sure if this works and if this workaround is what you are looking for...

regards,

Anthony