topic Re: Listbox Colours on Access Point - Qlikview in QlikView

Listbox Colours on Access Point - Qlikview

craig157 — Sat, 16 Nov 2024 21:14:07 GMT

Hi All,

I've altered my Listbox default colours in Qlikview so that it's gray, dark gray font & highlight colour of bright pink to fit the marketing specifications.

Unfortunately when I go onto access point it's pulling through the colours from another project (set up a previous employee) and I can't seem to find how to amend this.

I am just using the simple macro to update the colours (in edit module):

example:

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

RGB(204,45,111)

Qlikview x64: How it should look and does look on the Qlikview Application.What is looks like on AccessPoint:

Any advice would be great! Thanks

Re: Listbox Colours on Access Point - Qlikview

marcus_sommer — Fri, 15 Mar 2019 12:01:28 GMT

AFAIK those settings will be stored within the settings.ini - with the macro you set them for your local user but you couldn't do it for the server in the same way else you need to stop your server and adjust the settings.ini manually. You should make a BACKUP before you changed anything.

- Marcus

Re: Listbox Colours on Access Point - Qlikview

craig157 — Fri, 15 Mar 2019 14:46:08 GMT

Thanks Marcus. Weirdly the CustSel Colors do not match what we currently have running.

SetColorPrefs Macro:

sub SetColorPrefs()

Dim UserPrefs

set UserPrefs = _
ActiveDocument.GetApplication.GetuserPreferences

' Selected colour
UserPrefs.CustomSelBgColor(1).PrimaryCol.Col = _
RGB (244, 144, 30) 'PulseHighLightColour

UserPrefs.CustomSelFgColor(1).PrimaryCol.Col = _
RGB (255, 255, 255) 'White

'Possible Colour
UserPrefs.CustomSelBgColor(2).PrimaryCol.Col = _
RGB (68, 68, 68) 'PulseWindowColour

UserPrefs.CustomSelFgColor(2).PrimaryCol.Col = _
RGB (255, 255, 255) 'White

' Excluded Colour
UserPrefs.CustomSelBgColor(5).PrimaryCol.Col = _
RGB (68, 68, 68) 'Light Grey

UserPrefs.CustomSelFgColor(5).PrimaryCol.Col = _
RGB (87, 87, 87) 'Black

' Locked Colour
UserPrefs.CustomSelBgColor(0).PrimaryCol.Col = _
RGB (255, 0, 0) 'Red

UserPrefs.CustomSelBgColor(0).PrimaryCol.Col = _
RGB (0, 0, 0) 'Black

ActiveDocument.GetApplication.SetUserPreferences _
UserPrefs
end sub

From the Settings.ini file:

CustSelFgColors0=65535
CustSelBgColors0=0
CustSelFgColors1=16777215
CustSelBgColors1=2003188
CustSelFgColors2=16777215
CustSelBgColors2=4473924
CustSelFgColors3=0
CustSelBgColors3=255
CustSelFgColors4=0
CustSelBgColors4=16777215
CustSelFgColors5=5723991
CustSelBgColors5=4473924
CustSelFgColors6=14211288
CustSelBgColors6=8421504
CustSelFgColors7=14211288
CustSelBgColors7=8421504

Re: Listbox Colours on Access Point - Qlikview

marcus_sommer — Fri, 15 Mar 2019 14:59:57 GMT

It's only a different notation of the used colors. To get more background to it and to find the corresponding rgb() respectively the reversed way, take a look here: Colors-in-Qlik.

- Marcus

Re: Listbox Colours on Access Point - Qlikview

craig157 — Fri, 15 Mar 2019 15:37:20 GMT

Brilliant - not used Decimal for Colour assignment before.

Found from your article it's an RGB to VB Decimal Colour Converting.

https://convertingcolors.com/

Decent converter attached to go along with your QVW:

https://convertingcolors.com/

Thanks again Marcus!