topic Re: Change selection color in QlikView

Change selection color

Tue, 25 Mar 2014 12:19:21 GMT

Is it possible to change selection color in list from green to any other color

Re: Change selection color

PrashantSangle — Tue, 25 Mar 2014 12:24:58 GMT

Hi,

There is not Much Option to change Selection Color but you can do this in

Go To Document Property->-General>Selection Apperantice,

Try Style and Color Scheme,

Regards,

Re: Change selection color

jsingh71 — Tue, 25 Mar 2014 12:30:15 GMT

It is Possible.

Go to Document Properties and then under Genral Tab, select Custom from color scheme drop dpwn.

Re: Change selection color

Tue, 25 Mar 2014 12:30:21 GMT

Hi Max,

In Color Scheme [Custom] option is there but by choosing custom option where we can set color

Thanks,

Prakash

Re: Change selection color

Tue, 25 Mar 2014 12:32:57 GMT

Hi jsingh71,

I've set color scheme to custom, but can u please tell me from where u've set blue color after choosing custom scheme.

Thanks,

Prakash

Re: Re: Change selection color

jsingh71 — Tue, 25 Mar 2014 12:36:13 GMT

Its automatically takes the blue color.

For mor detail find the attachment. Still have any issue let me know.

Re: Change selection color

Tue, 25 Mar 2014 12:46:15 GMT

Hi,

I've opened your file but it is showing selection in Green color which is showing blue in your system,

Is there any other setting affecting on that

Thanks,

Prakash

Re: Change selection color

ThornOfCrowns — Tue, 25 Mar 2014 12:50:12 GMT

There is a way to manipulate the colours using a QAR, google for "qlikfix any colour, as long as it's green"

Re: Re: Change selection color

jsingh71 — Tue, 25 Mar 2014 12:55:51 GMT

Ok Prakash,

Do the following:

1) Press ctrl+M ( To open Edit Module Window).

2). Then Paste Below Code

Sub SetColorPrefs()

Dim UserPrefs

set UserPrefs = _

ActiveDocument.GetApplication.GetUserPreferences

' Set the "Selected" Color

UserPrefs.CustomSelBgColor(1).PrimaryCol.Col = _

RGB (0,0,255) ' Blue

UserPrefs.CustomSelFgColor(1).PrimaryCol.Col = _

RGB (255,255,0) ' Yellow

' Set the "Possible" Color

UserPrefs.CustomSelBgColor(2).PrimaryCol.Col = _

RGB (255,255,0) ' Yellow

UserPrefs.CustomSelFgColor(2).PrimaryCol.Col = _

RGB (0,0,0) ' Black

' Set the Excluded Color

UserPrefs.CustomSelBgColor(5).PrimaryCol.Col = _

RGB (200,200,200) ' Light gray

UserPrefs.CustomSelFgColor(5).PrimaryCol.Col = _

RGB (0,0,0) ' Black

' Set the Locked Color

UserPrefs.CustomSelBgColor(0).PrimaryCol.Col = _

RGB (255,0,0) ' Red

UserPrefs.CustomSelFgColor(0).PrimaryCol.Col = _

RGB (0,0,0) ' Black

ActiveDocument.GetApplication.SetUserPreferences _

UserPrefs

end sub

4) Click on Check Button to Check the code if it is showing '***Ready*****' then click on click on test button to execute the code.

Now again go to document properties and do the same which I tell you earlier. If Still facing problem let me know.

--Jai

Re: Change selection color

Tue, 25 Mar 2014 13:21:49 GMT

Hi Prakash,

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

Thanks & Regards,

Harshal Patil

Re: Change selection color

Anonymous — Fri, 13 Jun 2014 13:53:55 GMT

Hi, I'm doing a list box and trying to change the selection color as well. I have my list box presentation as "Windows Checkboxes" though so the code you gave doesnt change anything unless I set them back to the default. Any way I can keep them as checkboxes but change the color still?

Re: Change selection color

Thu, 06 Nov 2014 09:18:02 GMT

I've followed this and this works great, but one question I've got is how to reset the preferences back to the default?

Re: Change selection color

Thu, 23 Jul 2015 14:53:26 GMT

Hi Singh,

This is good.

Where can i get the properties list like Primarycolor(),CustomSelBgColor()......

thanks

Sai

Re: Change selection color

dineshkumar — Thu, 01 Oct 2015 07:59:39 GMT

Hi Harshal,

this is perfectly working but i want to change the default yellow colour of the background. how can i proceed further?

Re: Change selection color

Wed, 07 Oct 2015 06:55:52 GMT

Hi dinesh,

please give more idea on what exactly u r looking for color change on listBox level or else.

Re: Change selection color

dineshkumar — Thu, 08 Oct 2015 13:09:42 GMT

Hi Harshal,

i got it, by changing RGB in edit module . Thank you

Re: Change selection color

Fri, 23 Dec 2016 13:10:58 GMT

Bro !!!

i want to change the selection colour Only green to blue

Please suggest that

Re: Change selection color

pernillet — Thu, 20 Jun 2019 11:34:19 GMT

I have made this macro work, but when I publish is, then the selection colors don't change.

Is there some setting I am missing, or isn't it posible to do on the accesspoint via Macros?

Re: Re: Change selection color

hamy_IT_Dev — Sun, 14 Jul 2019 06:41:50 GMT

I tried . But didn't affect

Re: Change selection color

shabarish0587 — Fri, 23 Aug 2019 08:05:16 GMT

Hi Pernillet,

Have you got any solution on this. because i am also facing same issue now. i have created macro for changing default color to Custom color after creating when i publish i am getting default color selection not custom selection. if you got solution please help me on this.Thanks in Advance.

Regards,

S. Shabarish