topic Change colour of selected (active) field in QlikView

Change colour of selected (active) field

Thu, 29 Dec 2011 10:16:23 GMT

Dear all,

Is it possible to change the colours of the active (selected) and passive fields in a list?

The colour "green" is the selected field, I would like to change this to another colour...

I can't find an option to change this colours in the properties of the field, so I think I have to use an expression?

Thanks in advance!

Change colour of selected (active) field

SunilChauhan — Thu, 29 Dec 2011 10:18:23 GMT

its not possible to change selected clour fro greeen to any other

Re: Change colour of selected (active) field

johnw — Thu, 29 Dec 2011 20:36:30 GMT

You can create fake list boxes out of chart objects, which gives you a lot more control over formatting. See attached example.

Unfortunately, it also prevents some list box features, such as control click to select multiple values. It also takes more effort. So I would recommend just using standard list boxes, and getting used to the green and gray.

Change colour of selected (active) field

Anonymous — Thu, 16 Feb 2012 10:49:32 GMT

Hope this link will be give some more idea for your problem

http://community.qlik.com/message/185582

Regards

Ashok

Re: Change colour of selected (active) field

Thu, 16 Feb 2012 14:34:42 GMT

If you want to use a macro, you can change the Background color of a selected field, using the following:

set up = ActiveDocument.GetApplication.GetUserPreferences

up.CustomSelBgColor(1).PrimaryCol.Col = RGB (0,0,0)

ActiveDocument.GetApplication.SetUserPreferences up

end sub

indexes

0=locked

1=selected

2=optional

3=deselected

4=alternative

5=excluded

6=excluded selected

7=excluded locked

Re: Change colour of selected (active) field

Thu, 16 Feb 2012 15:41:16 GMT

Go to Settings -> Document Properties -> Triggers

I added it to "OnOpen"

Edit Actions -> Add -> External -> Run Macro

There you have to add the name of the macro.

I just realized that I forgot the first line of the code above. It should start with

"sub [name of the macro]"

I hope this helps.

Re: Change colour of selected (active) field

Thu, 16 Feb 2012 16:02:29 GMT

When I do everything as I described the colors in the listboxes are changed as specified.

You have to save and reopen the document, because you added the action to the trigger of opening the document.

One last thing you might have to do is go to

Settings -> Document Properties -> General -> Color Scheme and choose [Custom].

Sorry if I incorrectly presumed that you already did so, because you wanted to change the colors.

Re: Change colour of selected (active) field

Anonymous — Fri, 17 Feb 2012 05:37:49 GMT

If you want your listbox selected field color depends upon your choice then you can create saparete theme for that listbox.

Regards

Ashok

Re: Change colour of selected (active) field

Anonymous — Fri, 17 Feb 2012 06:16:11 GMT

Hi,

I have workout for your problem in qlikview 9.0 but is there no option and no way to change the listbox active/background selected value color.

I have tried using the themes also but i cant find the favour solution for you

I hope there is no such an option in qlikview 9

Regards

Ashok

Change colour of selected (active) field

ekech_infomotio — Fri, 17 Feb 2012 07:17:49 GMT

Thanks, Susann! - regards, Edgar

Change colour of selected (active) field

CELAMBARASAN — Fri, 17 Feb 2012 07:28:20 GMT

Hi,

Check with the options available in Document Properties-->General Tab-->Under the selection appearance by changing the color scheme.

Celambarasan

Change colour of selected (active) field

Anonymous — Fri, 17 Feb 2012 07:45:41 GMT

http://community.qlik.com/message/83648

in this link you have information how to change the background color of listbox in qlikview 10

Regards

Ashok

Change colour of selected (active) field

ekech_infomotio — Fri, 17 Feb 2012 08:05:39 GMT

So for now it works on Qlikview-Desktop, but requires me to save the app to get the colors. Also, if I put my application on the server it won't work for now - neither AJAX, nor IE-Plugin. Is there a solution to get the custom colors to work on the server or isn't it possible because user colors do not work in general on the server / via the accesspoint?

regards,

Edgar

Change colour of selected (active) field

Fri, 17 Feb 2012 08:39:22 GMT

So far I only tried it with QlikView-Desktop. So unfortunately I can't tell you if it also works on the server or help you with getting it to work.

If you find out, I'd be happy to know about it though.

Re: Change colour of selected (active) field

Tue, 03 Sep 2013 08:57:04 GMT

@Susann

Thanx for your macro code it's working properly as per matching need of changing Listbox selection color ...

Regards,

Harshal Patil

Re: Change colour of selected (active) field

neetu_singh — Wed, 04 Sep 2013 12:02:19 GMT

Hi,

there is an option to change the color i.e. In Document Properties ------> General tab -----> Selection Appearance (@ Bottom Right) ------> Color Scheme.

Apart of this you can not change the by default color.

Regards

Neetu Singh

Re: Change colour of selected (active) field

Wed, 04 Sep 2013 12:39:32 GMT

You can change color of selected field ...follow below instructions

Settings -> Document Properties -> General -> Color Scheme and choose [Custom].

now

Go to Settings -> Document Properties -> Triggers

add to "OnOpen"

Action Type: External / Run Macro

Name the Macro and Pest the following code...

sub [Enter Name of your Macro]

set up = ActiveDocument.GetApplication.GetUserPreferences

up.CustomSelBgColor(1).PrimaryCol.Col = RGB (255,0,0)

ActiveDocument.GetApplication.SetUserPreferences up

end sub

Then TEST it & done it